一对多查询,多表即b表取最新的一条记录
思路: 先两表联查,根据b表时间排序,构成一个子查询
外围在进行一个对关联id的分组查询()
select * from (SELECT m.*, ms.mh_id,ms.day,ms.day_power_add from dl_machine as m left join dl_machine_sealing as ms on m.id=ms.mh_id where m.user_id=210859 and m.status=1
ORDER BY ms.day desc limit 0, 100000000000) as a group by a.mh_id