select date(log_time) as log_day,user_id,hobby
from login_tb l join user_action_tb u using(user_id)
where log_time in (select min(log_time) as log_time
from login_tb 
group by date(log_time))