MySql 数据库 group 分组 排序 每组获取最新一条

SELECT * FROM (SELECT * FROM `cmf_users_liverecord` ORDER BY id desc ) test where islive='1' GROUP BY uid ORDER BY id desc;