How can I use PDO::FETCH_CLASS for pure database queries in Yii2?

Question

Yii

class User
{
    public $id;
    public $name;
}

$sql = "SELECT id, name FROM users";

$sth = Yii::$app->db->pdo->prepare($sql);
$sth->execute();
$sth->fetchAll(PDO::FETCH_CLASS, 'User');

How can such a query be made in Yii2 using Yii::$app->db->createCommand()?
Only needed for logging.
PS : This is just an example! ActiveRecord is not relevant here.

Answer 1

use DataReader
for this purpose For example:

class User extends \yii\base\Object
{
    public $id;
    
    public $name;
}

$query = new \yii\db\Query;
$query->select(['id', 'name'])->from('users');
$command = $query->createCommand(Yii::$app->db);
$reader = $command->query();
while ($user = $reader->readObject(User::className(), [])){
    $users[] = $user;    
}

Answer 2

Good afternoon.
Everything is described in the documentation
And more
And more
An example from the documentation:

$command = (new \yii\db\Query())
    ->select(['id', 'email'])
    ->from('user')
    ->where(['last_name' => 'Smith'])
    ->limit(10)
    ->createCommand();

// показать SQL запрос
echo $command->sql;
// показать привязываемые параметры
print_r($command->params);

What exactly doesn't work for you?

Answer 3

$sql = "SELECT id, name FROM users";
$command = Yii::$app->db->createCommand($sql);
$users = $command->queryAll(\PDO::FETCH_CLASS);
/**
 * или
 * $users= $command->queryAll(8);
 **/