Filter query join by id

Hi, i’m trying to only get one referenced item by id from table (users) in my table (transactions).

This is only returning one transaction ^ I would like to return all transaction items but only return the users connected to each transaction and not call any more than that.

image

Can someone guide me please

Community Page
Last updated: