with tiaojian as (
select 
user_id,
count(user_id) as cnt
from(
select
fdate,
user_id,
row_number()over(partition by user_id order by fdate) as pn
from tb_dau 
) as t 
group by user_id,subdate(fdate,pn)
)


select 
user_id,
max(cnt) as max_consec_days
from tiaojian 
group by user_id