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;