mysql 分组、最新数据优先于group，分页同时处理

如图，需要根据user_id进行分组，最新的数据优先于分组，结合limit:

相关sql:

SELECT
	a.id,
	a.user_id,
	a.user_name,
	a.create_time,
	a.remark
FROM
	`itd_authentication_qqwx_log` a
INNER JOIN (
	SELECT
		Max(id) id
	FROM
		itd_authentication_qqwx_log
	WHERE
		(`authentication_type` = 1)
	AND (`check_status` = 1)
	GROUP BY
		user_id
) b ON a.id = b.id
ORDER BY a.id desc
LIMIT 0,15
;