with early as (
    select
        date(log_time) as log_day,
        min(log_time) as early_time
    from login_tb
    group by date(log_time)
)

select 
    e.log_day,
    uat.user_id,
    uat.hobby
from early e
join login_tb lt on lt.log_time = e.early_time
join user_action_tb uat on uat.user_id = lt.user_id
order by log_day