您可以使用以下 MySQL 查询来生成近 30 天的所有日期:
SELECT DATE_ADD(CURDATE(), INTERVAL -30 + NUM DAY) AS date
FROM (
SELECT @i := @i + 1 AS NUM
FROM (
SELECT 0 UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SEL