Inserting data from sql query into Mysql table using PDO

I'm extracting some data from different tables in an oracle database into an array.
I'm trying to insert the fields into a mysql table using PDO connection.

this is the query I make:

$query = "SELECT field1, field2, field3 FROM table1;

$ORACLE_STATIC = OCIParse($ORACLE_CONNECT, $query);
OCIExecute($ORACLE_STATIC, OCI_DEFAULT);

Select allOpen in new window

what is the correct way of inserting all the rows from the query using PDO?
I have about 20 fields and 500k rows.