sort relation model count yii2

Sorting a Yii2 Relation Model Count

To sort a Yii2 relation model count, you can use the withCount() method in Yii2. This method allows you to retrieve the count of related records and sort them accordingly.

Here's an example of how you can use withCount() to sort a relation model count in Yii2:

$models = Model::find()
    ->withCount(['relation'])
    ->orderBy(['relation_count' => SORT_DESC])
    ->all();

In this example, Model represents the model you want to retrieve, and relation represents the relation you want to count and sort by. The withCount() method retrieves the count of related records and assigns it to the relation_count attribute. The orderBy() method is used to sort the models based on the relation_count attribute in descending order.

Please note that you need to replace Model with the actual name of your model class and relation with the name of your relation.

I hope this helps! Let me know if you have any further questions.