select date(log_time) as log_day
,t1.user_id
,hobby
from login_tb t
join user_action_tb t1 on t.user_id=t1.user_id
where log_time in (select min(log_time) from login_tb t2 group by date(log_time))