mysql如果订单日期中不存在数据

SELECT
EXTRACT( DAY FROM date) AS day,
EXTRACT( MONTH FROM date) AS month, who, sum ( wsd ) AS total FROM weekly
WHERE season = '08'
AND status = 1
AND who = 'NAME SURNAME'
GROUP BY day, month


day month who           total
12  8     NAME SURNAME  18
SELECT
EXTRACT( DAY FROM date) AS day,
EXTRACT(