Is there a UI tool for moving data from two different tables? The schemas in the two databases are different. Eg.

Database 1 / users
- id
- name
- phone

Database 2 / users
- id
- first_name
- mobile

Is there a tool that lets me visually create the statements or do the transform / copying the data?

Using MySQL by the way :)
Why use a UI tool when the query is this short?

INSERT INTO db1.users (id, name, phone)
    SELECT id, first_name, mobile FROM db2.users;


Caveats:  You probably should not copy id if it is AUTO_INCREMENT.  I was guessing which direction you wanted to copy.