Fhulufhelo Mokhomi

你见过吗 https://github.com/fhulufhelo/Get-Last-Record-in-Each-MySQL-Group ? 对我有用

$sql = "SELECT c.id, c.name,  c.email, r.id, r.companyid, r.name,  r.email FROM companytable c LEFT JOIN ( SELECT * FROM revisiontable  WHERE id  IN ( SELECT MAX(id)  FROM revisiontable  GROUP BY companyid ))  r ON a.cid=b.r.id";