连表查询取最新时间
SELECT
u.name,
l.*
FROM
t_user u
LEFT JOIN t_log l ON l.user_id = u.id
WHERE
u.NAME = 'wcs'
and NOT EXISTS ( SELECT 1 FROM t_log lo WHERE l.user_id = lo.user_id AND lo.create_time > l.create_time );
SELECT
u.*,
o.operate_time,o2.system_type
FROM
t_user u
LEFT JOIN (
select max(operate_time) as operate_time,user_id
from t_log
where operate_type=0 and user_id='3f1a28e58eca4a42be52bdce4d5bacd4'
group by user_id
) o on u.id=o.user_id
left join t_log o2 on o2.operate_time=o.operate_time and o2.user_id=o.user_id