public $viewFields = array(
'seller_reg'=>array('seller_id','seller_name','account','reg_time','_type'=>'LEFT'),
'seller'=>array('class_id','business_id','sheng','shi','xian','big_class_order','small_class_order','profile','tags','stopinfo','atmosphere','recommend','feature','min_consumption','prefer_lever','prefer','poi','pid','rong_id','rong_discount','address','tel','businesstime','per_money','attention','temp_id','logo','brand','status','_on'=>'seller_reg.seller_id=seller.seller_id','_type'=>'LEFT'),
'area'=>array('_as' => 'shi','title'=>'shititle','_on'=>'seller.shi=shi.area_id'),
'area'=>array('_as' => 'sheng','title'=>'shengtitle','_on'=>'seller.sheng=sheng.area_id'),
'area'=>array('_as' => 'xian','title'=>'xiantitle','_on'=>'seller.xian=xian.area_id','_type'=>'LEFT'),
'business'=>array('business_name', '_on'=>'Business.business_id=seller.business_id','_type'=>'LEFT'),
'seller_class'=>array('class_name', '_on'=>'seller.class_id=seller_class.class_id','_type'=>'LEFT'),
'prefer'=>array('prefer_id', '_on'=>'seller.seller_id=prefer.seller_id'),
);最后，结果始终只出来一个区域的名称，也不报错，模型解析出来的SQL如下：SELECT seller_reg.seller_id AS seller_id,seller_reg.seller_name AS seller_name,seller_reg.account AS account,seller_reg.reg_time AS reg_time,seller.class_id AS class_id,seller.business_id AS business_id,seller.sheng AS sheng,seller.shi AS shi,seller.xian AS xian,seller.big_class_order AS big_class_order,seller.small_class_order AS small_class_order,seller.profile AS profile,seller.tags AS tags,seller.stopinfo AS stopinfo,seller.atmosphere AS atmosphere,seller.recommend AS recommend,seller.feature AS feature,seller.min_consumption AS min_consumption,seller.prefer_lever AS prefer_lever,seller.prefer AS prefer,seller.poi AS poi,seller.pid AS pid,seller.rong_id AS rong_id,seller.rong_discount AS rong_discount,seller.address AS address,seller.tel AS tel,seller.businesstime AS businesstime,seller.per_money AS per_money,seller.attention AS attention,seller.temp_id AS temp_id,seller.logo AS logo,seller.brand AS brand,seller.status AS status,xian.title AS xiantitle,business.business_name AS business_name,seller_class.class_name AS class_name,prefer.prefer_id AS prefer_id FROM local_seller_reg seller_reg LEFT JOIN local_seller seller ON seller_reg.seller_id=seller.seller_id LEFT JOIN local_area xian ON seller.xian=xian.area_id LEFT JOIN local_business business ON Business.business_id=seller.business_id LEFT JOIN local_seller_class seller_class ON seller.class_id=seller_class.class_id LEFT JOIN local_prefer prefer ON seller.seller_id=prefer.seller_id 最佳答案
