Listing of Date Range using MySQL

Hi is there a way on listing up a date (Within a range) using MySQL ?. Such that we can populate it up.

Example

|date       |  Active   |  Terminated  |
|--------------------------------------|
|2012-02-10 |    15     |       9      |
|2012-02-11 |    11     |       1      |
|2012-02-12 |    16     |     NULL     |
|2012-02-13 |   NULL    |      22      |
|2012-02-14 |    1      |      11      |
|2012-02-15 |   NULL    |       5      |

|... Until

|2020-08-12 |   19      |      77      |

---------------------------------------

By using a MySQL, I queried also from my database to get the following (Like as shown on table query)

The "Active" column is from other table (LEFT JOIN BY DATE respective to the populated ones)

The "Terminated" column is from other table (LEFT JOIN BY DATE respective to the populated ones)

C'mon my brain! ;(

Thank you! I hope there's a workaround