自己写的sql，链表查询后分页不可用，求大神帮助！ [ 2.0 版本 ]

//控制器方法

获取试题的 列表 按照单个试题备考数倒序排列

$querySql = "select a.id,b.catename,a.title,a.total_num,a.pass_num,(a.pass_num / a.total_num) as passagv from et_question as a inner join et_category as b on a.courseware_id=b.cateid where b.`level`=3 order by a.total_num desc";
$questionOneData = $category->findBySql($querySql);
$dataProvider = new ActiveDataProvider([
    'query' => $questionOneData,
    'pagination' => [
        'pagesize' => '2',
    ]
]);

//视图代码

<div class="user-index">
    <?=
    GridView::widget([
        'dataProvider' => $dataProvider,
        'columns' => [
            [
                'format' => 'raw',
                'label' => '考卷名称',
                'value' => function ($dataProvider) {
                    if ($dataProvider->id) {
                        return Html::a($dataProvider->title, Yii::$app->urlManager->createUrl(['/statistical/training-active', 'id' => $dataProvider->id]), [
                                    'title' => '查看',
                                    'style' => 'margin-right:5%',
                                    'data-pjax' => 0,
                        ]);
                    }
                }],
                    ['attribute' => '归属课程', 'value' => function($model) {
                            return $model['catename'];
                        }],
                    ['attribute' => '已考次数', 'value' => function($model) {
                            return $model['total_num'];
                        }],
                    ['attribute' => '通过率', 'value' => function($model) {
                            return round($model['passagv'], 3) * 100 . '%';
                        }],
                ],
            ]);
            ?>
</div>