MySQL怎樣查詢所有用戶最新的一條信息

select `users`.*, `message`.* from `users`
left join (select * from `message` where id in ( select max(id) as maxid from `message` group by `js_id`) ) as d on `d`.`js_id` = `users`.`id`
order by `d`.`created_at` desc, `users`.`id` asc;

沒有入庫時間和自增主鍵嗎，排序取第一條