SELECT
   ls.REGIST_DATE
   ,(
      CASE strftime('%w',SUBSTR(ls.REGIST_DATE, 1, 10))
         WHEN '0' THEN '日'
         WHEN '1' THEN '月'
         WHEN '2' THEN '火'
         WHEN '3' THEN '水'
         WHEN '4' THEN '木'
         WHEN '5' THEN '金'
         WHEN '6' THEN '土'
      END
   ) WK
   ,IFNULL(dt.TOTAL, 0) TOTAL
FROM
   (
                SELECT '2022-08-01' REGIST_DATE
      UNION ALL SELECT '2022-08-02' REGIST_DATE
      UNION ALL SELECT '2022-08-03' REGIST_DATE
      UNION ALL SELECT '2022-08-04' REGIST_DATE
      UNION ALL SELECT '2022-08-05' REGIST_DATE
      UNION ALL SELECT '2022-08-06' REGIST_DATE
      UNION ALL SELECT '2022-08-07' REGIST_DATE
      UNION ALL SELECT '2022-08-08' REGIST_DATE
      UNION ALL SELECT '2022-08-09' REGIST_DATE
      UNION ALL SELECT '2022-08-10' REGIST_DATE
      UNION ALL SELECT '2022-08-11' REGIST_DATE
      UNION ALL SELECT '2022-08-12' REGIST_DATE
      UNION ALL SELECT '2022-08-13' REGIST_DATE
      UNION ALL SELECT '2022-08-14' REGIST_DATE
      UNION ALL SELECT '2022-08-15' REGIST_DATE
      UNION ALL SELECT '2022-08-16' REGIST_DATE
      UNION ALL SELECT '2022-08-17' REGIST_DATE
      UNION ALL SELECT '2022-08-18' REGIST_DATE
      UNION ALL SELECT '2022-08-19' REGIST_DATE
      UNION ALL SELECT '2022-08-20' REGIST_DATE
      UNION ALL SELECT '2022-08-21' REGIST_DATE
      UNION ALL SELECT '2022-08-22' REGIST_DATE
      UNION ALL SELECT '2022-08-23' REGIST_DATE
      UNION ALL SELECT '2022-08-24' REGIST_DATE
      UNION ALL SELECT '2022-08-25' REGIST_DATE
      UNION ALL SELECT '2022-08-26' REGIST_DATE
      UNION ALL SELECT '2022-08-27' REGIST_DATE
      UNION ALL SELECT '2022-08-28' REGIST_DATE
      UNION ALL SELECT '2022-08-29' REGIST_DATE
      UNION ALL SELECT '2022-08-30' REGIST_DATE
      UNION ALL SELECT '2022-08-31' REGIST_DATE
   ) ls LEFT OUTER JOIN (
      SELECT
         SUBSTR(CONFIRMED_AT, 1, 10) CONFIRMED_AT
         ,COUNT(*) TOTAL
      FROM
         USERS
      WHERE
         CONFIRMED_AT LIKE '2022-08%'
         AND VALID_FLG = '1'
      GROUP BY
         SUBSTR(CONFIRMED_AT, 1, 10)
   ) dt ON (
      ls.REGIST_DATE = dt.CONFIRMED_AT
   )