SQL query on 2 databases on different (mysql) servers

Hello.

First, I make it clear that I do not know if this is possible.

I'm trying to do a SQL query where I need the INNER JOIN data from 02 tables that are on different servers (a Local Server and another Remote Server).

I want to do in PHP using mysqli. But I tried everything and I could not.

If anyone knows and can help me, I'll be very grateful.

Thanks in advance.