MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();


version()


8.0.36


create table events (id serial, start date, end date, each_month int);
insert into events (start,end,each_month) values
(20240303,20300101,2),
(20240403,20300101,1)

Records: 2  Duplicates: 0  Warnings: 0


with recursive expanded_events as (
    select id, start as orig_start, end, each_month,
        start, 1 as counter
    from events
    where start <= '2024-07-31'

    union all

    select id, orig_start, end, each_month,
        orig_start + interval counter*each_month month, counter+1
    from expanded_events
    where
        orig_start + interval counter*each_month month <= least(end,'2024-07-31')
)
select id, start
from expanded_events
where start between '2024-02-02' and '2024-07-31'
order by id, start


id
start


1
2024-03-03

1
2024-05-03

1
2024-07-03

2
2024-04-03

2
2024-05-03

2
2024-06-03

2
2024-07-03

id	start
1	2024-03-03
1	2024-05-03
1	2024-07-03
2	2024-04-03
2	2024-05-03
2	2024-06-03
2	2024-07-03