SELECT 1 AS '月份' UNION ALL
SELECT 2 AS '月份' UNION ALL
SELECT 3 AS '月份' UNION ALL
SELECT 4 AS '月份' UNION ALL
SELECT 5 AS '月份' UNION ALL
SELECT 6 AS '月份' UNION ALL
SELECT 7 AS '月份' UNION ALL
SELECT 8 AS '月份' UNION ALL
SELECT 9 AS '月份' UNION ALL
SELECT 10 AS '月份' UNION ALL
SELECT 11 AS '月份' UNION ALL
SELECT 12 AS '月份'
使用 UNION ALL或者UNION 连接 数据
将这个表 作为 主表 Left Join 连接 数据表
连接条件 就是 月份 = MONTH(数据表的时间列)
可以看到12分的数据为0
如果使用GROUP BY 的话 12月份就不会显示