with
    t as (
        select distinct
            date (log_time) as log_day,
            user_id,
            rank() over (
                partition by
                    date (log_time)
                order by
                    log_time 
            ) as rk
        from
            login_tb
    )

select 
t.log_day,
t.user_id,
hobby
from 
t 
left join 
user_action_tb
using(user_id)
where t.rk=1
order by t.log_day