How do you display items by id through a linked table in Yii2?

Question

Yii

I have an intermediate table.
Let's say we have a relationship between three tables.

tovar             zakaz_tovar            user
id                   id                           id
title               id_tovar                  name
                     id_user 

 public function getUser(){
        return $this->hasMany(User:className(), ['id' => 'id_user'])
            ->viaTable('zakaz_tovar', ['id_tovar' => 'id']);

    }

If I make a request $model=Product::findOne($id);
and then through the loop I try to display user, then it displays not in the order of the entry in zakaz_product, but by user id. How to make records displayed by id from the intermediate table?

Answer 1

Add to condition.->orderBy('id ASC');

public function getUser(){
        return $this->hasMany(User:className(), ['id' => 'id_user'])
            ->viaTable('zakaz_tovar', ['id_tovar' => 'id'])->orderBy('id_tovar ASC');
    }

public function getUser(){
        return $this->hasMany(User:className(), ['id' => 'id_user'])
            ->viaTable('zakaz_tovar', ['id_tovar' => 'id'])->orderBy('id DESC');
    }