近一年新用户注册量

	select date_format(dts.create_date,'%Y-%m'),IF (ps.total is NULL ,0,ps.total) toatal from
    (select
    @num := @num+1 rownum,
    date_format(DATE_ADD(DATE_SUB(date_format(NOW(),'%y-%m-%d'),INTERVAL 12 MONTH),INTERVAL 	@num MONTH),'%y-%m-%d') create_date
    from user , (select @num:=0) t
    where  @num < 12 
    ) dts 
    LEFT JOIN (SELECT  DATE_FORMAT(create_date, '%y-%m-%d') dfc, count(*) total
    FROM user u 
    GROUP BY date_format(dfc, '%Y-%m'))as ps
    ON date_format(ps.dfc,'%y-%m') =  date_format(dts.create_date,'%y-%m')
    ORDER BY dts.create_date DESC