INSERT SELECT in Yii?

Question

MySQL

How to make such a request

INSERT INTO users_log (id, email)<br>
SELECT id, email FROM users<br>

With AR?

Answer 1

Yii::app()->db->createCommand(
  "INSERT INTO users_log (id, email)
    SELECT id, email FROM users"
)->execute();

Answer 2

No way, choose separately give AR and she inserts.

Answer 3

ActiveRecord was conceived for other purposes. Think about the name "ActiveRecord" - an active record. That is, operations are preferably with one record - reading, writing, selecting by foreign keys, deleting, etc.
Your idea is clear, such things are done by direct request.