field('A.id,A.name,A.state,A.app_bb,IFNULL(U.us,0) as unum')->JOIN("(SELECT appid,COUNT(*) AS us FROM {$DP}user GROUP BY appid) AS U",'A.id=U.appid')->where('A.state',"y")->select(); ?>