select * from
(SELECT
u.id,
u.mobile,
u.nickname,
u.sex,
u.country,
u.province,
u.city,
u.app,
u.channel,
u.createtime AS ucreatetime,
l.updatetime AS lastlogintime,
l.id as lid
FROM
user AS u
LEFT JOIN log AS l ON u.id = l.uid
ORDER BY u.id,l.id DESC
) tmp
GROUP BY tmp.id
user 表 : log表 = 1:n
uid 关联
查询每个user的最后一次登录的时间