Yii：相关表格的默认排序模型

Question

I have a three tables, "pets", "species" and "homes." Homes have multiple pets, each of which has a species. The species can be mixed in a home.

Is it possible to use findByPk() on a house and have the associated pets sorted by species then name?

Hendersons
--------------
Cat "Hairball"
Cat "Princess"
Dog "Ace"
Dog "Killer"

This is probably blindingly obvious to someone, but I'm not finding an answer.

Answer 1

With Carlos' help, here's the functional code, in "homes" model:

'pets' => array(self::MANY_MANY, 'Pets', 'home_id',
                'order'=>'species.name ASC',
                'with'=>'species')

Pretty simple. Thanks, Carlos.