使用MySQL 產生某個區間的時間

WITH RECURSIVE Date_Ranges AS (
    SELECT '2023-06-01' AS Date
   UNION ALL
   SELECT Date + INTERVAL 1 DAY
   FROM Date_Ranges
   WHERE Date < '2023-10-05')
SELECT * FROM Date_Ranges;