MySQL查询近12个月数据，无则补0

查询近12个月数据，无则补0

select v.month,ifnull(b.count,0)  count from (
    SELECT DATE_FORMAT(CURDATE(), %Y-%m) AS `month` 
    UNION SELECT DATE_FORMAT((CURDATE() - INTERVAL 1 MONTH), %Y-%m) AS `month` 
    UNION SELECT DATE_FORMAT((CURDATE() - INTERVAL 2 MONTH), %Y-%m) AS `month` 
    UNION SELECT DATE_FORMAT((CURDATE() - INTERVAL 3 MONTH), %Y-%m) AS `month` 
    UNION SELECT DATE_FORMAT((CURDATE() - INTERVAL 4 MONTH), %Y-%m) AS `month` 
    UNION SELECT DATE_FORMAT((CURDATE() - INTERVAL 5 MONTH), %Y-%m) AS `month` 
    UNION SELECT DATE_FORMAT((CURDATE() - INTERVAL 6 MONTH), %Y-%m) AS `month` 
    UNION SELECT DATE_FORMAT((CURDATE() - INTERVAL 7 MONTH), %Y-%m) AS `month` 
    UNION SELECT DATE_FORMAT((CURDATE() - INTERVAL 8 MONTH), %Y-%m) AS `month` 
    UNION SELECT DATE_FORMAT((CURDATE() - INTERVAL 9 MONTH), %Y-%m) AS `month` 
    UNION SELECT DATE_FORMAT((CURDATE() - INTERVAL 10 MONTH), %Y-%m) AS `month` 
    UNION SELECT DATE_FORMAT((CURDATE() - INTERVAL 11 MONTH), %Y-%m) AS `month`
) v 
left join
(select 
 left(create_time,7) as month,count(*) as count
from t_user as a	
		where DATE_FORMAT(a.create_time,%Y-%m)>
		DATE_FORMAT(date_sub(curdate(), interval 12 month),%Y-%m) and del_flag=0
		GROUP BY month
)b
on v.month = b.month group by v.month

表为： t_user

时间字段为：create_time