$query = User::find()
->where([‘id’=>[1,2,3,4])
->select([‘username’])
// get the AR raw sql in YII2
$commandQuery = clone $query;
echo $commandQuery->createCommand()->getRawSql();
$users = $query->all();
$query = User::find()
->where([‘id’=>[1,2,3,4])
->select([‘username’])
// get the AR raw sql in YII2
$commandQuery = clone $query;
echo $commandQuery->createCommand()->getRawSql();
$users = $query->all();