获取mysql中不包括周末的两个日期之间的列出日期

SELECT DATE_ADD(start_date, INTERVAL t.n DAY) AS date
FROM (
    SELECT '2022-01-01' AS start_date, '2022-01-31' AS end_date
) AS d
JOIN (
    SELECT a.n + b.n * 10 + c.n * 100 AS n
    FROM (SELECT 0 AS n UNION SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7 UNION SELECT 8 UNION SELECT 9) AS a
    CROSS JOIN (SELECT 0 AS n UNION SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7 UNION SELECT 8 UNION SELECT 9) AS b
    CROSS JOIN (SELECT 0 AS n UNION SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7 UNION SELECT 8 UNION SELECT 9) AS c
) AS t
WHERE DATE_ADD(start_date, INTERVAL t.n DAY) <= end_date
AND WEEKDAY(DATE_ADD(start_date, INTERVAL t.n DAY)) NOT IN (5, 6)
ORDER BY date;