$Model= M();
$Model->query(" SELECT *,(SELECT sum(mpay) FROM `cr_order` AS b WHERE b.gid = a.gid AND status='4') AS myorder ,(SELECT count(nid) FROM `cr_order` AS c WHERE c.gid = a.gid AND status='4') AS mydding FROM `cr_office` As a order by myorder desc limit 5");


这种查询，如何用TP的子查询做？