mysql计算每月的第一周

SELECT 
    DATE_FORMAT(date, '%Y-%m-%d') AS date,
    YEARWEEK(date, 1) AS week_number
FROM 
    (SELECT DATE_SUB('2023-04-01', INTERVAL DAYOFMONTH('2023-04-01') - 1 DAY) + INTERVAL n DAY AS date
     FROM (SELECT 0 n UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6) numbers
     WHERE DATE_SUB('2023-04-01', INTERVAL DAYOFMONTH('2023-04-01') - 1 DAY) + INTERVAL n DAY BETWEEN '2023-04-01' AND '2023-04-30') AS dates
WHERE 
    YEARWEEK(date, 1) = YEARWEEK(DATE_SUB('2023-04-01', INTERVAL DAYOFMONTH('2023-04-01') - 1 DAY), 1);

SELECT 
    DATE_FORMAT(date, '%Y-%m-%d') AS date,
    YEARWEEK(date, 1) AS week_number,
    CASE
        WHEN YEAR(date) = YEAR(DATE_SUB(date, INTERVAL DAYOFMONTH(date) - 1 DAY)) THEN 'First Week'
        ELSE 'Other Week'
    END AS week_type
FROM 
    (SELECT DATE_SUB('2023-04-01', INTERVAL DAYOFMONTH('2023-04-01') - 1 DAY) + INTERVAL n DAY AS date
     FROM (SELECT 0 n UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6) numbers
     WHERE DATE_SUB('2023-04-01', INTERVAL DAYOFMONTH('2023-04-01') - 1 DAY) + INTERVAL n DAY BETWEEN '2023-04-01' AND '2023-04-30') AS dates;