How to import and export data from MYSQL Table to/from a file, please explain with example?

Question

How can I insert data into one table from two other tables where i have three tables namely users, role and userrole.
Now I want to insert the data into userrole table from users table and role table with a single statement.