queryColumn(); $brothers[]=$parentid; $str=implode(",",$brothers); $arr=sql("select province,count(province) as count from {{article}} where province>1 and menuid in ($str) group by province")->queryAll(); $provincearr=array(); foreach($arr as $v){ $provincearr[]=$v['province']; } if(!empty($provincearr)){ $areas=sql("select area_id,area_name from {{areas}} where area_id in (".implode(",",$provincearr).")")->queryAll("area_id"); } foreach($arr as $k => $v){ $arr[$k]['name']=$areas[$v['province']]['area_name']; } ?>
{$v.name}({$v.count})