MySQL根据时间筛选用户最新的一条记录

select t.*
from (SELECT *
from person where create_time<'2022-08-01 00:00:00' HAVING 1
order by create_time desc)c
group by c .code;