We are going to deploy the new yiiframework.com website on March 23, 2018 from 8:00 to 12:00 UTC.
Website and Yii documentation will not be available in this time frame. Check the news for more details.
When one needs to select a record in a table that do not have related records through a relation, it is generally suggested to use a subquery.
Personnaly, I prefer a high level approach, and I have a method to do it with scopes.