By Finance Crypto

I have two separate databases in the same host (localhost:3306). I have one table from the first database and a second from the other database. Here is 2 screenshots to become more clear enter image description here

enter image description here

I need to match:

ID -> username
EMAIL -> email
FIRST_NAME -> first_name
LAST_NAME -> last_name

Is there any automatic way with a software? Need I to write some specific query to copy these 4 columns from one table to another? I search on internet but I didn’t find any example. For the info, the first picture is the ldap users from keycloack and the second one is the imported users to an app with sso auth.

Till now I copied manually the records of users.

thanks

databasemariadbphpmyadminsql