mysql 柱状图统计_mysql图表统计，补全日期

SELECT

od.date,

SUM(od.money)

FROM

(

SELECT

SUM(money) money,

DATE_FORMAT(create_time, '%Y-%m-%d') date

FROM

red_packet_number

WHERE

create_time > '2019-1-01'

AND create_time < '2019-1-31'

GROUP BY

DATE_FORMAT(create_time, '%Y-%m-%d')

UNION (SELECT 0, '2019-01-01')

UNION (SELECT 0, '2019-01-02')

UNION (SELECT 0, '2019-01-03')

UNION (SELECT 0, '2019-01-04')

UNION (SELECT 0, '2019-01-05')

UNION (SELECT 0, '2019-01-06')

UNION (SELECT 0, '2019-01-07')

UNION (SELECT 0, '2019-01-08')

UNION (SELECT 0, '2019-01-09')

UNION (SELECT 0, '2019-01-10')

UNION (SELECT 0, '2019-01-11')

UNION (SELECT 0, '2019-01