统计今年12个月所有数据，没有数据的月份也显示

SELECT
            a.date,
//round取两位小数，ifnull判断是否为空
            round(ifnull( s.outputyear, 0 ) ,2) as Xout
//取今年的十二个月份
        FROM
            (
        SELECT concat( DATE_FORMAT( NOW( ), '%Y' ), '-01' ) AS date UNION
        SELECT concat( DATE_FORMAT( NOW( ), '%Y' ), '-02' ) AS date UNION
        SELECT concat( DATE_FORMAT( NOW( ), '%Y' ), '-03' ) AS date UNION
        SELECT concat( DATE_FORMAT( NOW( ), '%Y' ), '-04' ) AS date UNION
        SELECT concat( DATE_FORMAT( NOW( ), '%Y' ), '-05' ) AS date UNION
        SELECT concat( DATE_FORMAT( NOW( ), '%Y' ), '-06' ) AS date UNION
        SELECT concat( DATE_FORMAT( NOW( ), '%Y' ), '-07' ) AS date UNION
        SELECT concat( DATE_FORMAT( NOW( ), '%Y' ), '-08' ) AS date UNION
        SELECT concat( DATE_FORMAT( NOW( ), '%Y' ), '-09' ) AS date UNION
        SELECT concat( DATE_FORMAT( NOW( ), '%Y' ), '-10' ) AS date UNION
        SELECT concat( DATE_FORMAT( NOW( ), '%Y' ), '-11' ) AS date UNION
        SELECT concat( DATE_FORMAT( NOW( ), '%Y' ), '-12' ) AS date
            ) a
//（这里是要查询表的信息）
            LEFT JOIN (
        SELECT
            p.time,p.out as Xout
        FROM
            system p 
        WHERE
             p.time=DATE_FORMAT(now(),'%Y')
            AND p.id IS NOT NULL
        GROUP BY
            p.time
            ) s 
	ON a.date = p.time order by a.date