How to build queries in constructor with JOIN in Yii2?

Question

Yii

Good afternoon, I
need to make the following request:

Comments::find()
                ->select('с.text, с.date_create, с.firstname, с.lastname')
                ->innerJoin('{{%users}} as u', 'с.user_id  = u.id')
                ->where(['с.status' => Comments::STATUS_PUBLIC])

How can I set the short name "c" for the comments table?
And another question:
How can I access attached data?
this query is used in ActiveDataProvider

Answer 1

Comments::find()
    ->select('с.text, с.date_create, с.firstname, с.lastname')
    ->from([Comments::tableName() . ' с'])
    ->innerJoin('{{%users}} as u', 'с.user_id  = u.id')
    ->where(['с.status' => Comments::STATUS_PUBLIC])

Answer 2

How can I set the short name "c" for the comments table?

Comments::find()->form(['c' => 'comments'])
but in general it is better to use standard data binding tools