How to sort ActiveRecord with with in yii1 by category sort order?

Question

Yii

Good afternoon,
There are 2 tables (products and category) and 2 models( Products and Category )
products
----------
id
name
category_id
=========
category
------- ---
id
name
order_sort (int)
=========

class Products extends ActiveRecord{
...
public function relations() {
    return [
            'category'              =>      [self::BELONGS_TO,  'Category', 'category_id'],
        ];
}

That is, the products must be grouped into categories in the sort order of the categories. Tried like this:

$model = Products::model()->with(
            'category',[
                'order' =>  'order_sort ASC'
            ] )->findAll();

But apparently wrong, tell me, if not difficult.

Answer 1

Offhand, using CDbCriteria:

$criteria = new CDbCriteria;
$criteria->with=['category']
$criteria->order='category.order_sort ASC';

$model = Products::model()->findAll($criteria);