select t3.user_id
from register_tb t3
join 
(select user_id, 连续登录分组, count(*) 连续登录天数
from
 (
    select user_id,
    date_sub(date(log_time),interval row_number() over(partition by user_id order by log_time) day) 连续登录分组
from login_tb
) t1
group by user_id, 连续登录分组
) t2
on t3.user_id=t2.user_id 
where t2.连续登录天数>=3
order by t3.user_id