How can i join firebase web database nodes from foreign Keys and Primary Keys?

This is my database and i want to check for the seat status in Seats node and if its booked i want to take the name of the user who booked it by the Orders table How can i join these 2 tables in order to take the value? This is the reference link by firebase Database image One Databse Image 2

Thanks in advance for any help