查询多用户登录日志表倒数第二条数据
SELECT *
FROM user_log AS l1
WHERE (
SELECT COUNT(DISTINCT l2.id)
FROM user_log AS l2
WHERE l2.user_acount= l1.user_acount AND l2.id > l1.id and l2.user_acount in ('zhanghao1','zhanghao2')
) = 1 and l1.user_acount in ('zhanghao1','zhanghao2')
GROUP BY l1.user_acount