mysql按天分组，自动补全缺少的天

SELECT time,sum FROM(
select DATE_FORMAT(create_time,'%d') time,count(*) sum from about_pojo WHERE create_time IS NOT null group by time
UNION SELECT '01' as time,'0' as sum
UNION SELECT '02' as time,'0' as sum
UNION SELECT '03' as time,'0' as sum
UNION SELECT '04' as time,'0' as sum
UNION SELECT '05' as time,'0' as sum
UNION SELECT '06' as time,'0' as sum
UNION SELECT '07' as time,'0' as sum
UNION SELECT '08' as time,'0' as sum
UNION SELECT '09' as time,'0' as sum
UNION SELECT '10' as time,'0' as sum
UNION SELECT '11' as time,'0' as sum
UNION SELECT '12' as time,'0' as sum
UNION SELECT '13' as time,'0' as sum
UNION SELECT '14' as time,'0' as sum
UNION SELECT '15' as time,'0' as sum
UNION SELECT '16' as time,'0' as sum
UNION SELECT '17' as time,'0' as sum
UNION SELECT '18' as time,'0' as sum
UNION SELECT '19' as time,'0' as sum
UNION SELECT '20' as time,'0' as sum
UNION SELECT '21' as time,'0' as sum
UNION SELECT '22' as time,'0' as sum
UNION SELECT '23' as time,'0' as sum
UNION SELECT '24' as time,'0' as sum
UNION SELECT '25' as time,'0' as sum
UNION SELECT '26' as time,'0' as sum
UNION SELECT '27' as time,'0' as sum
UNION SELECT '28' as time,'0' as sum
UNION SELECT '29' as time,'0' as sum
UNION SELECT '30' as time,'0' as sum
UNION SELECT '31' as time,'0' as SUM
)aa GROUP BY time;