SELECT
  MONTH_T.A AS REGIST_DATE
  , MONTH_T.B AS WK
  , IFNULL(USERS_GORUP.CNT, 0) AS TOTAL 
FROM
  ( 
    SELECT
      '2022-08-01' AS A
      , '月' AS B 
    UNION 
    SELECT
      '2022-08-02'
      , '火' 
    UNION 
    SELECT
      '2022-08-03'
      , '水' 
    UNION 
    SELECT
      '2022-08-04'
      , '木' 
    UNION 
    SELECT
      '2022-08-05'
      , '金' 
    UNION 
    SELECT
      '2022-08-06'
      , '土' 
    UNION 
    SELECT
      '2022-08-07'
      , '日' 
    UNION 
    SELECT
      '2022-08-08'
      , '月' 
    UNION 
    SELECT
      '2022-08-09'
      , '火' 
    UNION 
    SELECT
      '2022-08-10'
      , '水' 
    UNION 
    SELECT
      '2022-08-11'
      , '木' 
    UNION 
    SELECT
      '2022-08-12'
      , '金' 
    UNION 
    SELECT
      '2022-08-13'
      , '土' 
    UNION 
    SELECT
      '2022-08-14'
      , '日' 
    UNION 
    SELECT
      '2022-08-15'
      , '月' 
    UNION 
    SELECT
      '2022-08-16'
      , '火' 
    UNION 
    SELECT
      '2022-08-17'
      , '水' 
    UNION 
    SELECT
      '2022-08-18'
      , '木' 
    UNION 
    SELECT
      '2022-08-19'
      , '金' 
    UNION 
    SELECT
      '2022-08-20'
      , '土' 
    UNION 
    SELECT
      '2022-08-21'
      , '日' 
    UNION 
    SELECT
      '2022-08-22'
      , '月' 
    UNION 
    SELECT
      '2022-08-23'
      , '火' 
    UNION 
    SELECT
      '2022-08-24'
      , '水' 
    UNION 
    SELECT
      '2022-08-25'
      , '木' 
    UNION 
    SELECT
      '2022-08-26'
      , '金' 
    UNION 
    SELECT
      '2022-08-27'
      , '土' 
    UNION 
    SELECT
      '2022-08-28'
      , '日' 
    UNION 
    SELECT
      '2022-08-29'
      , '月' 
    UNION 
    SELECT
      '2022-08-30'
      , '火' 
    UNION 
    SELECT
      '2022-08-31'
      , '水'
  ) MONTH_T 
  LEFT JOIN ( 
    SELECT
      date (CONFIRMED_AT) AS ymd
      , COUNT(*) AS CNT 
    FROM
      USERS 
    WHERE
      VALID_FLG = '1' 
    GROUP BY
      date (CONFIRMED_AT)
  ) USERS_GORUP 
    ON MONTH_T.A = USERS_GORUP.ymd