I'm having trouble writing a query

select credit, link, collaborators.instagram, groups.id as group, theme from
groups join memberships on groups.id = memberships.group
join collaborators on collaborators.id = memberships.collaborator
where collab = 12

[
  {
    "theme": "group 1s theme",
    "collaborators": [{"credit": "my name jeff", "link": "google.com", "instagram": "jeff"}, {"credit": "asdf", "link": "google.com", "instagram": "asdf"}]
  },
  {
    "theme": "group 2s theme",
    "collaborators": [{"credit": "ulfrick", "link": "google.com", "instagram": "stormcloak69"}]
  }
]

  const { data, error } = await supabase.from<definitions["groups"]>("groups").select(`
  theme,
  collab (
    collaborators (
      credit
    )
  )`).eq('collab', id);

  const { data, error } = await supabase.from<definitions["groups"]>("groups").select(`
  theme,
  collaborators (
      credit
  )`).eq('collab', id);