发一个优化的Yii2 试用的千万级数据分页 [ 2.0 版本 ]

use app\models\User;
use yii\data\Pagination;

        $subQuery = User::find()->select('id')->where('id>0');
        $count = $subQuery->count();

        $pagination = new Pagination(['totalCount' => $count]);

        $subQuery->offset($pagination->offset)
            ->limit($pagination->limit);

        $query = User::find()->select('*')->from(['t1' => User::tableName(), 't2' => $subQuery])->where('t1.id=t2.id')->all();

        $articles = $query->offset($pagination->offset)
            ->limit($pagination->limit)
            ->all();

        print_r($articles);