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))