// SELECT t1.*, t2.total FROM image_package t1 LEFT JOIN ( SELECT package_id, COUNT(*) AS total FROM images GROUP BY package_id ) t2 ON t1.id = t2.package_id
$rows = Db::table('image_package')
->alias('t1')
->join('( SELECT package_id, COUNT(*) AS total FROM images GROUP BY package_id ) t2', 't1.id = t2.package_id', 'left')
->select();
return ['status' => 200, 'data' => $rows]; 最佳答案
