is UNION available in PHQL?

because i have error while performing my query, but i already tested it on mysql console, and it works.

here is my query:

SELECT a.name, SUM(d.amount) as total FROM App\Models\Modela a JOIN ( SELECT b.ida, b.amount FROM App\Models\Modelb b UNION ALL SELECT c.ida, c.amount FROM App\Models\Modelc c ) AS d ON d.ida = a.ida GROUP BY a.id_a