Why is the data not output via CONCAT?

Question

Yii

Tell me why data may not be displayed via CONCAT

$query = self::find()->select(['id', 'CONCAT(name, sname) AS fname'])->all();

Separately (without concat) all fields are displayed, but with concat - id is displayed and fname is not.

Answer 1

$query = self::find()->select(['id', new \yii\db\Expression('CONCAT(name, sname) AS fname')])->all();