Querying a specific key and value in an array

[
  {
    name: "maria",
    email: "maria@mail.pt"
  },
  {
    name: "john",
    email: "john@mail.pt"
  },
  {
    name: "paola",
    email: "paola@mail.pt"
  },
]

[
  {
    name: "maria",
    email: "maria@mail.pt"
  },
  {
    name: "john",
    email: "john@mail.pt"
  },
  {
    name: "paola",
    email: "paola@mail.pt"
  },
]

  const {data, error} = await supabase
    .from('users')
    // only the "users" that have a friend with "john@mail.pt"

  const {data, error} = await supabase
    .from('users')
    // only the "users" that have a friend with "john@mail.pt"