SELECT
A.DATE AS REGIST_DATE,
CASE strftime("%w", A.DATE)
    WHEN "0" THEN "日"
    WHEN "1" THEN "月"
    WHEN "2" THEN "火"
    WHEN "3" THEN "水"
    WHEN "4" THEN "木"
    WHEN "5" THEN "金"
    WHEN "6" THEN "土"    
END as WK,
IFNULL(COUNT(USER_CODE),0) AS TOTAL
FROM (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
LEFT OUTER JOIN USERS ON DATE(CONFIRMED_AT) = A.DATE AND VALID_FLG = "1"
AND A.DATE BETWEEN "2022-08-01" AND "2022-08-31"
GROUP BY A.DATE
ORDER BY A.DATE ASC