with t as (
    select date(CONFIRMED_AT) as dt
    from users
    where valid_flg=1
), s as (
    select date('2022-08-01') as REGIST_DATE,
    substr('日月火水木金土', strftime("%w", date('2022-08-01'))+1, 1) as WK,
    (select count(*) from t where t.dt = date('2022-08-01')) as TOTAL
    union all
    select date(REGIST_DATE,'+1 days'), 
    substr('日月火水木金土', strftime("%w", date(REGIST_DATE,'+1 days'))+1, 1),
    (select count(*) from t where t.dt = date(REGIST_DATE,'+1 days'))
    from s
    where REGIST_DATE<date('2022-08-31')
)
select * from s