Sql：主表与子表的最新记录级联查询

SELECT * FROM MainTable m
LEFT JOIN (SELECT d.*
FROM (SELECT MAX(clc.Id) AS id FROM ChildTable AS clc GROUP BY clc.ParentId) t
LEFT JOIN ChildTable AS d ON t.id = d.Id ) ccd ON ccd.ParentId = cc.Id