WITH T1 AS(
    SELECT
        '2022-08-01' AS REGIST_DATE
    UNION ALL
    SELECT
        DATE(REGIST_DATE, '+1 days')
    FROM
        T1
    WHERE
        REGIST_DATE < '2022-08-31'
),
T2 AS(
    SELECT
        DATE(CONFIRMED_AT) AS REGIST_DATE,
        COUNT(USER_CODE) AS TOTAL
    FROM
        USERS
    WHERE
        CONFIRMED_AT IS NOT NULL
        AND REGIST_DATE BETWEEN '2022-08-01' AND '2022-08-31'
        AND VALID_FLG = '1'
    GROUP BY
        REGIST_DATE
)
SELECT
    T1.REGIST_DATE,
    SUBSTR('日月火水木金土', STRFTIME('%w', T1.REGIST_DATE) + 1, 1) AS WK,
    IFNULL(TOTAL, 0) AS TOTAL
FROM
    T1
LEFT OUTER JOIN
    T2 ON T2.REGIST_DATE = T1.REGIST_DATE