public function GetData() { $model = new app\base\IModel(); $query = $model->GetQuery(); $result = $query->select('content.id, content.name, content.parent_id, url.url, url.action, module.file_controller, module.name as module')->leftJoin('url', "content.id = url.page_id")->leftJoin('module', 'module.id = url.module')->where(['content.isdirectory' => 1, 'content.visible' => 1])->from('content')->all(); return $result; }