many-to-many returns empty array

I have the following tables:

account

account

account

account =>

id

id

, ...

sheet

sheet

sheet

sheet =>

id

id

, ...

connected_sheets

connected_sheets

connected_sheets

connected_sheets =>

pk(account_id, sheet_id)

pk(account_id, sheet_id)

pk(account_id, sheet_id)

pk(account_id, sheet_id),

fk(account_id)

fk(account_id)

fk(account_id)

fk(account_id),

fk(sheet_id)

fk(sheet_id)

fk(sheet_id)

const { data, error} = await supabaseClient
    .from('account')
    .select(`
      *,
      sheet(sheet_id)
    `)
    .eq('id', id)
    .single();

const { data, error} = await supabaseClient
    .from('account')
    .select(`
      *,
      sheet(sheet_id)
    `)
    .eq('id', id)
    .single();

const { data, error} = await supabaseClient
    .from('account')
    .select(`
      *,
      sheet(sheet_id)
    `)
    .eq('id', id)
    .single();

const { data, error} = await supabaseClient
    .from('account')
    .select(`
      *,
      sheet(sheet_id)
    `)
    .eq('id', id)
    .single();

I have inserted a row in the join table that connects the account with that same id to a sheet

But I get this response:

{
  id: "66",
  ...,
  sheet: []
}

{
  id: "66",
  ...,
  sheet: []
}

{
  id: "66",
  ...,
  sheet: []
}

{
  id: "66",
  ...,
  sheet: []
}

What am I doing wrong here?