Dao如何分页 [ 2.0 版本 ]

找到一个
控制器
use yii\data\Pagination;
$sql = "select * from goods join category on goods.cat_id=category.id";
$command = Yii::$app->db->createCommand($sql)->queryAll();

$pages = new Pagination(['totalCount' => count($command),'pageSize'=>'5']);
$data = Yii::$app->db->createCommand($sql." limit ".$pages->limit." offset ".$pages->offset."")->queryAll();
return $this->render('index',['data'=>$data,'pages' => $pages]);
视图
<?PHP
echo LinkPager::widget([

 'pagination' => $pages,

]);
?>