(Staff_Member varchar(13), Start_Date date)

;

INSERT INTO t

(Staff_Member, Start_Date)

('team Member 1', '2019-06-25'),

('team Member 2', '2019-06-30')

;

select staff_member, start_date, 1 as week_number, start_date as week_start, start_date + interval 7 day as end_date

from t

union all

select staff_member, start_date, week_number + 1, end_date, end_date + interval 7 day

from cte

where year(start_date) = year(week_start)

)

select *

from cte

order by staff_member, week_start