MYSQL查询当前月每天的数据，没有设置0

SELECT date as 日期, IFNULL(tab.num, 0) as 数量 FROM (
SELECT
	@cdate := date_add( @cdate, INTERVAL - 1 DAY ) as date
FROM
	( SELECT @cdate := date_add(CURDATE(), INTERVAL + 1 DAY ) 
	FROM ccs_work_order
	)d1
	WHERE YEAR(@cdate)=YEAR(CURDATE()) 
	AND MONTH(@cdate)=MONTH(CURDATE()) 
	AND DAY(@cdate) > 1
	ORDER BY date
)date_c LEFT JOIN (
SELECT COUNT(*) as num, DATE(create_time) as t
FROM ccs_work_order WHERE YEAR(create_time)=YEAR(CURDATE()) AND MONTH(create_time)=MONTH(CURDATE())  GROUP BY DATE(create_time)
)tab ON DATE(t)=date
ORDER BY date desc;

只改表名（ccs_work_order）和时间列（create_time）

如果只是取15天，可以通过倒叙，用代码for循环15条记录。