create a new table for the query results

http://stackoverflow.com/questions/2698401/how-to-store-mysql-query-results-in-another-table

CREATE TABLE another_table SELECT /your query goes here/

 多建几张中间过渡用的表，无所谓的。