用户表:users 日志表:logs(外键:user_id,创建时间:created_at) 获取所有用户最新的日志: SELECT b.* from (SELECT user_id,max(created_at) as maxtime from logs GROUP BY user_id) as a LEFT JOIN logs as b ON b.created_at = a.maxtime AND b.user_id = a.user_id