How to make a subquery in yii2 or how to join two queries?

Question

Yii

Hello!
How to make a subquery in yii2?
I have two requests like this. How to merge two requests?

//Это первая
$subQuery = AreaSizes::find()->select(['name as SizeName'])
                                        ->from('area_sizes')
                                        ->innerJoin('area_sizes_rel','area_sizes_rel.size_id = area_sizes.id')
                                        ->all();
//Это вторая
$query = Areas::find()->select(['name as areaName'])
                                    ->from(['areas'])
                                    ->innerJoin('area_prices','area_prices.area_id = areas.id')
                                    ->innerJoin('area_sizes_rel', 'area_sizes_rel.area_id = areas.id')
                                    ->innerJoin('area_equipment', 'area_equipment.area_id = areas.id')
                                    ->innerJoin('area_photos','area_photos.area_id = areas.id')
                                    //->where(['id' => $subQuery])
                                    ->asArray()
                                    ->all();

Answer 1

->where(['in', 'name', $subQuery])