mysql – getting results less then current date for every date of a date range groupBy dates

i have a table with these columns and i have a query like

SELECT * FROM `table_name` WHERE `created_at` <= 'current_date' AND `status` = 'SUCCEEDED' AND `subscription_end_date` >= 'current_date'

which works only for current date(single date). but i need this result for every date in a date Range . groupBy date.

id subscription_end_date status created_at
1 2021-03-29 22:16:03 SUCCEEDED 2021-03-28 22:16:03
2 2021-03-30 21:16:03 SUCCEEDED 2021-03-29 22:16:03
3 2021-03-31 22:16:03 SUCCEEDED 2021-03-30 22:16:03

if date Range (2021-03-28 to 2021-03-30)desired result like:

2021-03-28 : (
              1 row
              )
2021-03-29 : (
              1 row
              )
2021-03-30 : (
              1 row
              )