common/models/Menu.php

<?php
namespace common\models;
use Yii;
/**
 * This is the model class for table "menu".
 *
 * @property integer $menu_id
 * @property integer $menu_pid
 * @property integer $menu_lft
 * @property integer $menu_rgt
 * @property integer $termin_id
 * @property integer $show
 * @property integer $sortorder
 */
class Menu extends \yii\db\ActiveRecord
{
    
    public function getMenuList()
    { 
        return yii::$app->db->createCommand('
            SELECT 
                `termin_lang`.termin_title, `termin_lang`.termin_id 
            FROM `menu`
                INNER JOIN `termin_lang` ON `termin_lang`.termin_id = `menu`.termin_id
                    AND `termin_lang`.lang_id = '.yii::$app->lang_id.'
            ORDER BY `menu`.menu_pid ASC, `menu`.sortorder ASC
        ')->queryAll();
/*
        return $this->find()
            ->selectOption('`termin_lang`.termin_title')
            ->from('menu')
            ->join(
                'INNER JOIN', 
                '`termin_lang`.termin_id = `menu`.termin_id', 
                ['lang_id' => yii::$app->lang_id])
            ->all();
*/
    }
    /**
     * @inheritdoc
     */
    public static function tableName()
    {
        return 'menu';
    }
    /**
     * @inheritdoc
     */
    public function rules()
    {
        return [
            [['menu_pid', 'menu_lft', 'menu_rgt', 'termin_id', 'show', 'sortorder'], 'safe'],
            [['menu_pid', 'menu_lft', 'menu_rgt', 'termin_id', 'show', 'sortorder'], 'integer']
        ];
    }
    /**
     * @inheritdoc
     */
    public function attributeLabels()
    {
        return [
            'menu_id' => Yii::t('app', 'Menu ID'),
            'menu_pid' => Yii::t('app', 'Menu Pid'),
            'menu_lft' => Yii::t('app', 'Menu Lft'),
            'menu_rgt' => Yii::t('app', 'Menu Rgt'),
            'termin_id' => Yii::t('app', 'Termin ID'),
            'show' => Yii::t('app', 'Show'),
            'sortorder' => Yii::t('app', 'Sortorder'),
        ];
    }
    public function getTermin_lang()
    {
        return $this->hasMany(Menu::className(), ['termin_id' => 'termin_id']);
    }  
}