分页的联表查询 [ 新手入门 ]

$data = $this->find()->select('a_table.*,b_table.*')->join('LEFT JOIN',' a_table ',' a_table. mid = b_table.id');
$pages = new Pagination(['totalCount' =>$data->count(), 'pageSize' => '10']);
$list = $data->offset($pages->offset)->limit($pages->limit)->asArray()->all();

简单用了一下这方法好像还行，不知道有没有什么好一点的建议，谢谢~