mysql中查询当月每一天的数据量没有的补零

select aa.DAY,(select count(*) from notice t where substr( t.create_time, 1, 10 )=aa.DAY
) as ss
from (SELECT
        date_add(DATE_ADD(curdate(), INTERVAL - DAY(curdate()) + 2 DAY),
        INTERVAL (cast( help_topic_id AS signed INTEGER ) - 1 ) DAY 
        ) DAY 
    FROM
        mysql.help_topic 
    WHERE
        help_topic_id < DAY ( last_day( curdate( ) ) ) 
    ORDER BY
        help_topic_id) aa