How to combine a query?

Question

PHP

Good day!
Don't tell me how

\R::find('master', 'id IN (' . \R::genSlots($viewed) . ') LIMIT 3', $viewed)

join this query with another table.
It displays everything well, except for the phone and the address
, my addresses and phone numbers are stored in another table.
It is necessary to make it so that it unites with the user table and clings the missing information from there.
c orm redbean is still poorly known. I haven't been able to find any clear instructions online on how to do this.

I write right away. I'm self-taught, I don't have anyone around to give me advice. I can use google.