mysql根据用户id分组查询出最新的数据

1.先用max(create_time) 查询出最新数据，并根据用户id分组

select user_id, max(create_time) as create_time from order_info group by user_id;

2.使用inner join 查询出其他字段信息

select 
     order_info.*
from order_info
     inner join (
             select user_id, 
                    max(create_time) as create_time 
             from order_info 
             group by user_id
     ) b on order_info.user_id = b.user_id and order_info.create_time = b.create_time;