mysql分组排序取出每组顺序第一条

-- 分组排序取出每组顺序第一条
select substring_index(group_concat(id order by create_time desc),',',1) from tb_order group by user_id