public static function getInfo($id) { $db = new yii\db\Query(); $db->from('ur_questions'); $db->leftJoin('ur_l', 'ur_questions.ur_l_id = ur_l.id'); $db->InnerJoin('region_ur_l', 'region_ur_l.id_ur = ur_l.id'); $db->InnerJoin('region', 'region_ur_l.id_reg = region.id'); $db->groupBy('ur_l.id'); $db->select(['ur_l.name as uname', 'GROUP_CONCAT(DISTINCT(region.name)) as rname', 'ur_l.contact_mail', 'ur_l.contact_phone', 'ur_l.contact_face', 'question', 'qfiles', 'ansver', 'ur_questions.created_at', 'ur_l.id', 'ur_questions.id as qid']); $db->where(['=', 'ur_questions.id', $id]); //$db->leftJoin('region', 'ur_l.region_id = region.id'); return $db->One(); }