How to make a dropdown list appear in the grid table filter?

Question

Yii

I know how to implement it, but I don’t understand how to implement it in yii2, I tried everything in sql, it outputs data normally, here is the sql code that I should get

SELECT otdel.id, otdel.fio FROM `zakaz` JOIN otdel WHERE zakaz.id_sotrud = otdel.id

And how do i implement in yii2
in grid table

[
                'attribute' => 'id_sotrud',
                'value' => 'idSotrud.fio',
                'filter' => Zakaz::getSotrudList()
            ],

And in the file frontend/models/Zakaz

public static function getSotrudList()
    {
        $sotruds = Zakaz::find()
        ->select(['otdel.id','otdel.fio'])
        ->join('JOIN','otdel', 'zakaz.id_sotrud = otdel.id')
        ->all();
    }

But in the end it is not possible to display the list and the data gets null

Answer 1

https://nix-tips.ru/yii2-razbiraemsya-s-gridview.html