How to make orderBy from 2 tables using AR with?

Question

Yii

There are 2 tables, paper and paper_category
, both have a position field by which I need to sort them.
Output should be like this
CATEGORY1
-paper1
-paper2
CATEGORY2
-paper5
-paper8
I do this

$array = Paper::find()->select(['id', 'title', 'cat_id', 'position'])->asArray()
            ->with(['category' => function($query) {
                $query->orderBy(['paper_category.position' => SORT_DESC]);
            }])
            ->orderBy(['paper.position' => SORT_DESC])
            ->all();
        return ArrayHelper::map($array, 'id', 'title', 'category.title');

Sort by paper, not by category.

Answer 1

You seem to be confusing with and joinWith. You have sent 2 requests. 1 took Paper, the second pulled category links, with 1 request for all Paper. Look in the sql logs that you received and everything will become clear.

Answer 2

UP
needed to add one more output field