SET @start_date = '2022-01-01';
SET @end_date = '2022-01-31';
WITH RECURSIVE DateSeries AS (
SELECT @start_date AS generated_date
UNION ALL
SELECT DATE_ADD(generated_date, INTERVAL 1 DAY)
FROM DateSeries
WHERE generated_date < @end_date
)
SELECT generated_date
FROM DateSeries;