Write sql query to join tables, how?

Question

Laravel

I need to write a script in which I need to merge 2 tables and save the result to a file so that later I can import these results into another table.
Question: what is the best way to do this in laravel? via console command?
I know how to make a sql query to join tables (left join), but I don’t understand how to save it to a table using lararavel tools. Tell me please

Answer 1

INSERT INTO SELECT