查询以显示所有月份，并在有相应月份数据的情况下显示值

SELECT months.month, IFNULL(data.value, 0) AS value
FROM (
    SELECT 'January' AS month
    UNION SELECT 'February'
    UNION SELECT 'March'
    UNION SELECT 'April'
    UNION SELECT 'May'
    UNION SELECT 'June'
    UNION SELECT 'July'
    UNION SELECT 'August'
    UNION SELECT 'September'
    UNION SELECT 'October'
    UNION SELECT 'November'
    UNION SELECT 'December'
) AS months
LEFT JOIN data ON months.month = MONTHNAME(data.date)
ORDER BY MONTH(data.date)