MySQL查询这个月的每一天数量

select date_format(create_time, '%Y-%m-%d') as create_time, count(*) as count 
from table 
where DATE_FORMAT(create_time,'%Y%m')=DATE_FORMAT(CURDATE(),'%Y%m') 
and cond = '123456'
GROUP BY create_time