How to display data from three tables in Yii2?

Question

Yii

There are 3 tables:
Profile - with a column - id
Skill-dictionary - id, skill Profile_skill -
id, id_profile,
id_skill in Skill-dictionary It is necessary to display the skill value from Skill-dictionary in the view profile (for the corresponding id profile). in the Profile.php model

public function getProfileSkills()
    {
        return $this->hasMany(ProfileSkill::className(), ['id_profile' => 'id'])
        ->joinWith(['id ProfileSkill'])
            ->joinWith(['id SkillDictionary']); 
       
    }

in profile controller

public function actionIndex()
    {
        $dataProvider = new ActiveDataProvider([
            'query' => Profile::find(),
        ]);

        return $this->render('index', [
            'dataProvider' => $dataProvider,
        ]);
    }

Answer 1

You have three tables, two with data, one binder, why do you need to display three?
https://yiiframework.com.ua/ru/doc/guide/2/db-acti...
Linking through an intermediate table