How to get referenced auth.user data from my teams table

I created a teams table in supabase and it has a column name created_by which is a foreign key referencing auth.user. How can i write a javascript client query to get all the team members with
created_by populated in it.

This is my code that i am using to get teams with its creator data.

const response = await supabase
.from(“team”)
.select(
id, name, members, created_by, auth.users (id, email, full_name, profile_picture), workspace_id
)