mysql 一对多关系获取最新记录

select m.user_id,m.longitude,m.latitude,substring_index(group_concat(m.create_time order by m.create_time desc),",",1) as atime from t_p_position m group by m.user_id;