How to Chain multiple selects

select * from chat_room_participants where user_uid='d0fc7e46-a8a5-4fd4-8ba7-af485013e6fa'
select * from chat_rooms where id=1
select * from chat_messages where chat_room_id=1