SELECT
DATE(CONFIRMED_AT) AS REGIST_DATE,
CASE strftime("%w", DATE(CONFIRMED_AT))
    WHEN "0" THEN "日"
    WHEN "1" THEN "月"
    WHEN "2" THEN "火"
    WHEN "3" THEN "水"
    WHEN "4" THEN "木"
    WHEN "5" THEN "金"
    WHEN "6" THEN "土"    
END as WK,
SUM(USER_CODE) AS TOTAL
FROM USERS
JOIN
(WITH RECURSIVE
  cnt(x) AS (VALUES(julianday('2022-08-01'))
  UNION ALL
   SELECT x+1 FROM cnt WHERE x < julianday('2022-08-31'))
SELECT x,strftime('%Y-%m-%d', x) AS DATE FROM cnt;) as A ON DATE(CONFIRMED_AT) = A.DATE
WHERE VALID_FLG = "1"
AND DATE(CONFIRMED_AT) BETWEEN "2022-08-01" AND "2022-08-31"
GROUP BY DATE(CONFIRMED_AT)
ORDER BY DATE(CONFIRMED_AT) ASC