MySQL Generate Tanggal

/* generate tanggal bulan ini */
SELECT tanggal
    FROM
    (
        SELECT MAKEDATE(YEAR(NOW()),1) +
        INTERVAL (MONTH(NOW())-1) MONTH +
        INTERVAL daynum DAY tanggal
        FROM
        (
            SELECT t*10+u daynum FROM
            (SELECT 0 t UNION SELECT 1 UNION SELECT 2 UNION SELECT 3) A,
            (SELECT 0 u 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) B ORDER BY daynum
        ) AA
    ) AA WHERE MONTH(tanggal) = MONTH(NOW());

/* generate tanggal bulan dan tahun tertentu, parameter $bulan dan $tahun */
SELECT tanggal
    FROM
    (
        SELECT MAKEDATE($tahun,1) +
        INTERVAL ($bulan-1) MONTH +
        INTERVAL daynum DAY tanggal
        FROM
        (
            SELECT t*10+u daynum FROM
            (SELECT 0 t UNION SELECT 1 UNION SELECT 2 UNION SELECT 3) A,
            (SELECT 0 u 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) B ORDER BY daynum
        ) AA
    ) AA WHERE MONTH(tanggal) = $bulan;

/* mysql 8 only */
SELECT DATE(CONCAT('$tahun-$bulan-',DAY)) tanggal FROM
(
WITH RECURSIVE `days` AS ( SELECT 1 AS `day` UNION ALL SELECT `day` + 1 FROM `days` WHERE `day` < DAY(LAST_DAY(DATE('$tahun-$bulan-1'))) ) SELECT * FROM `days`
) a ;