【笔记】Biny框架多联表格

//leftJoin的使用
$DAO = $this->modsDAO;
$DAO = $DAO->leftJoin($this->mods_typeDAO,array('mods_type_id'=>'id'));//左联接mods_type
$DAO = $DAO->leftJoin($this->gameDAO, array(array('game_id'=>'id')));//左联接game
$DAO = $DAO->leftJoin($this->userDAO, array(array('mods_publish'=>'id')));//左联接user

//进行数据筛选查询
$DAO = $DAO->filter(['mods' => array('!='=>array('mods_state'=>array(-1, -2,-5)))]);
$DAO = $DAO->filter(['mods' => array('mods_type_id'=>$modsType_id)]);

//分页并输出
$data = $DAO->limit(20, ($pageIndex-1) * 20)->query(array(
	'mods' => array('id','game_id','mods_type_id','mods_title','mods_image_url','mods_desc','mods_click_cnt','mods_download_cnt'),
	'mods_type' => array('mods_type_name'),
	'game' => array('game_path','game_name','game_imgUrl'),
	'user' => array('user_nickName')
));