当年12月数据 null为0 sql

SELECT
	e.date,
	IFNULL( count, 0 ) AS count 
FROM
	(
	SELECT
		date_format( d.date, '%m' ) AS date 
	FROM
		(
		SELECT
			adddate( DATE_SUB( CURDATE(), INTERVAL dayofyear( now())- 1 DAY ), INTERVAL numlist.id - 1 MONTH ) AS 'date' 
		FROM
			(
			SELECT
				@xi := @xi + 1 AS id 
			FROM
				( SELECT 1 UNION SELECT 2 UNION SELECT 3 ) xc1,
				( SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 ) xc2,
				( SELECT @xi := 0 ) xc0 
			) AS numlist 
		) AS d 
	) AS e
	LEFT JOIN ( SELECT date_format( reporting_time, '%m' ) AS mon, count( reporting_time ) AS count FROM hl_event GROUP BY mon ) AS f ON f.mon = e.date