SELECT
date_format( date_add( '2022-05-01', INTERVAL + t.help_topic_id MONTH ), '%Y-%m-%d' ) AS 'date'
FROM
mysql.help_topic t
WHERE
t.help_topic_id <= timestampdiff( MONTH, '2022-05-01', now( ) )
或者
select DATE_FORMAT( a.day, '%Y-%m-%d' ) AS date
from (
select curdate() - INTERVAL (a.a + (10 * b.a) + (100 * c.a) + (1000 * d.a) ) DAY as day
from (select 0 as a 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 select 8 union all select 9) as a
cross join (select 0 as a 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 select 8 union all select 9) as b
cross join (select 0 as a 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 select 8 union all select 9) as c
cross join (select 0 as a 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 select 8 union all select 9) as d
) a
where a.day between '2022-12-02' and now()
运行结果