MySQL 8.0

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

create table tablename(name varchar(20), course varchar(50), sdate date, enddate date);
insert into tablename values('Tanzeel', 'SQL Bootcamp', '2019-05-28', '2019-11-20');
select * from tablename


name
course
sdate
enddate


Tanzeel
SQL Bootcamp
2019-05-28
2019-11-20


with recursive cte as (
  select name, course, sdate, enddate 
  from tablename
  union all
  select name, course, sdate + interval 1 month, enddate
  from cte 
  where last_day(sdate) < enddate
)
select name, course, date_format(sdate, '%Y-%m') enrollMonth
from cte


name
course
enrollMonth


Tanzeel
SQL Bootcamp
2019-05

Tanzeel
SQL Bootcamp
2019-06

Tanzeel
SQL Bootcamp
2019-07

Tanzeel
SQL Bootcamp
2019-08

Tanzeel
SQL Bootcamp
2019-09

Tanzeel
SQL Bootcamp
2019-10

Tanzeel
SQL Bootcamp
2019-11

name	course	enrollMonth
Tanzeel	SQL Bootcamp	2019-05
Tanzeel	SQL Bootcamp	2019-06
Tanzeel	SQL Bootcamp	2019-07
Tanzeel	SQL Bootcamp	2019-08
Tanzeel	SQL Bootcamp	2019-09
Tanzeel	SQL Bootcamp	2019-10
Tanzeel	SQL Bootcamp	2019-11