how to fetch records from multiple database using php?

I need to fetch the records from 2 different databases using join or any other methods. I have created different connection to connect with two databases but I don't know how I can execute the query and which connection should I used to fetch the records. Any suggestions?