我有一个表内两个字段相关联的，需要一个关联查询。根据手册写了个视图模型如下：

class BangshouViewModel extends ViewModel {
   public $viewFields = array(
     'user'=>array('id','type','status','name','sex','phone','addtime','_as'=>'unit','_type'=>'LEFT'),
     'user'=>array('name'=>'rename','type_id','_as'=>'unitp', '_on'=>'unit.id=unitp.type_id'),
   );
 }

1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ON unit.id=unitp.type_id WHERE `type` = 1 LIMIT 1' at line 1 [ SQL语句 ] : SELECT COUNT(*) AS tp_count FROM da_user unitp ON unit.id=unitp.type_id WHERE `type` = 1 LIMIT 1