Yii2批量插入

use yii\db\Query;

$data = [
    ['name' => 'Alice', 'age' => 30],
    ['name' => 'Bob', 'age' => 25],
    ['name' => 'Charlie', 'age' => 35],
];

$query = new Query();
$query->createCommand()->batchInsert('user', ['name', 'age'], $data)->execute();

use yii\db\BatchInsert;

$data = [
    ['name' => 'Alice', 'age' => 30],
    ['name' => 'Bob', 'age' => 25],
    ['name' => 'Charlie', 'age' => 35],
];

$batchInsert = new BatchInsert('user', ['name', 'age']);
$batchInsert->data($data);
$batchInsert->execute();