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