By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table test (idate date, value int)
insert into test values ('2019-01-27', 1),
('2019-01-28', 2),
('2019-01-29', 3),
('2019-01-29', 4),
('2019-01-30', 5),
('2019-01-30', 6),
('2019-01-28', 7),
('2019-02-01', 8),
('2019-02-02', 9)
SELECT *
FROM test
WHERE idate >= SUBDATE(CURDATE(), WEEKDAY(CURDATE()))
ORDER BY idate
| idate | value |
|---|---|
| 2019-01-28 | 2 |
| 2019-01-28 | 7 |
| 2019-01-29 | 3 |
| 2019-01-29 | 4 |
| 2019-01-30 | 5 |
| 2019-01-30 | 6 |
| 2019-02-01 | 8 |
| 2019-02-02 | 9 |