SELECT
SUBSTRING_INDEX(MAX(CONCAT(create_time, ',', id)),',',-1) maxId,members_id membersId
FROM
grade_change_flow
WHERE
members_id > #{membersId}
and state = 1
GROUP BY
members_id
HAVING
count(*) > 1
ORDER BY
members_id asc
limit
50
如果ID不是自增的话,可以用id和创建时间合并为字符串排序,然后去除这个字符串的id