example

CODE:
Branch::find()
                ->where(['id' => $id])
                ->with(['branchcategories' => function($q) {
                        $q->select(['id', 'name', 'branch_id', '(select COUNT(*) from branchitem where branchcategory_id=branchcategory.id AND status = ' . Branchitem::STATUS_ACTIVE . ') AS thecount'])->where(['status' => Branchcategory::STATUS_ACTIVE])->having('thecount > 0');
                    }])->with(['branchcategories.branchitems' => function($q) {
                                $q->select(['id', 'name', 'description', 'price', 'branchcategory_id'])->where(['status' => Branchitem::STATUS_ACTIVE]);
                            }])
                                ->with(['branchcategories.branchitems.branchitempictures' => function($q) {
                                        $q->select(['id', 'src_thumb', 'restoitem_id'])->orderBy("id desc")->limit(1);
                                    }])
                                        ->select(['id'])
                                        ->asArray()
                                        ->one();
                                        
-------------------------------------------
                                        
EXECUTED QUERIES FROM DEBUGGER:

SELECT	SELECT `id`, `src_thumb`, `restoitem_id` FROM `branchitempicture` WHERE `restoitem_id` IN ('37', '42', '29', '36', '39', '41', '30', '40', '28', '38') ORDER BY `id` DESC LIMIT 1

SELECT	SELECT `id`, `name`, `description`, `price`, `branchcategory_id` FROM `branchitem` WHERE (`status`=10) AND (`branchcategory_id` IN ('4', '10')) ORDER BY `name`

SELECT	SELECT `id` FROM `branch` WHERE `id`=1