How to set a composite field in a Yii2 relationship?

Question

MySQL

Good afternoon,
There was a need to get the hasMany relationship using a composite field:

/**
     * Функция получения рейтинга компании
     * @return integer
     */
    public function getRating()
    {
        return $this->hasMany(Reviews::className(), ['chan_channel' => 'id'])->average('star');
    }

The fact is that in the Reviews table, you need to select records with company_id_{$company_id} in the chan_channel field and calculate AVG ('star') from these records.
That is, records with company_id_1 belong to the company with id=1.
How to specify the company_id_{$company_id} composite field in the hasMany method?

Answer 1

/**
     * Функция генерации строки идентификатора компании в таблице Review
     * @return boolean
     */
    public function getReview_id()
    {
        return 'company_id_'.$this->id;
    }

    /**
     * Функция получения рейтинга компании
     * @return integer
     */
    public function getRating()
    {
        return $this->hasMany(Reviews::className(), ['chan_channel' => 'review_id'])->average('star');
    }

In general, if anyone needs