How to form a union query in ActiveRecord yii2?

Question

Yii

here is the actual request

SELECT id, name_film, slug_film, created_at FROM `fl_film`)
UNION
 (SELECT id, name_mfilm, slug_mfilm, created_at FROM `fl_mfilm`)
UNION
 (SELECT id, name_serial, slug_serial, created_at FROM `fl_serial`)
ORDER BY `created_at` DESC
LIMIT 10

how to form a request.

Answer 1

So?

$query1 = MyModel::find()
    ->select("id, category_id AS type, name")
    ->limit(10);

$query2 = MyModel::find()
    ->select('id, type, name')
    ->limit(10);

$query1->union($query2);