Eager loading can be nested. For example, if for every comment, we also want to know its author, we could use the following ‘with’ find:

// find all posts together with their author and the author's profile

Post::model()->with('author','author.profile')->findAll();