SELECT b.*from(SELECT user_id,max(created_at)as maxtime from logs GROUPBY user_id)as a
LEFTJOIN logs as b
ON b.created_at = a.maxtime AND b.user_id = a.user_id
用户表: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.creat...