How to filter by the number of related models?

Question

Yii

There is an Author model with a hasMany posts relationship configured. By condition, I get an array of Author models along with posts. How at the ORM level not to include those Authors whose number of posts is zero?

Answer 1

use joinWith
like:

Author::find()->joinWith( 'posts', true, 'INNER JOIN' )