How to display data from linked table using Arrayelper::index?

Question

Arrays

My problem is that I could display the data so that they are grouped by date. I just don’t understand how to display data from related data
In the controller

$comment = Comment::find()->addSelect(['DATE(date) as just_date','TIME(date) as time','comment','id_user'])->where(['id_zakaz' => $id])->asArray()->all();
        $comment = ArrayHelper::index($comment, null, 'just_date');

And in the view

<?php foreach ($comment as $key=>$com){
                echo Yii::$app->formatter->asDate($key, 'php:j M Y').'<br>';
                foreach ($com as $value=>$name){
                    echo Yii::$app->formatter->asTime(ArrayHelper::getValue($name, 'time'), 'php:H:i').' '.ArrayHelper::getValue($name, 'comment').' '.ArrayHelper::getValue($name, 'id_user').'<br>';
                }
            } ?>

That is, I need id_user->idUser->name. Only I have an idea to make another request, but will it be logical to make another request in the request

Answer 1

load related data with joinWith and then choose what you need