i am trying to select a user row from a users table that has a column with an id in it that refrences to an id in another table which has name column and etc. How do i fetch the user from users table and have the name values of the other table using the foreign key

Perhaps this will give you the example you're looking for. https://supabase.com/docs/reference/javascript/select