获取当前周的所有日期，从周一到周日mysql

SELECT WEEKDAY(CURDATE()) AS weekday;

SELECT (WEEKDAY(CURDATE()) + 7 - 1) % 7 AS days_diff;

SELECT DATE_SUB(CURDATE(), INTERVAL (WEEKDAY(CURDATE()) + 7 - 1) % 7 DAY) AS monday_date;

SET @monday_date = DATE_SUB(CURDATE(), INTERVAL (WEEKDAY(CURDATE()) + 7 - 1) % 7 DAY);

SELECT DATE_ADD(@monday_date, INTERVAL (seq - 1) DAY) AS week_date
FROM (
    SELECT 1 AS seq UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7
) AS seq_table;