Get the categories/subcategories an author has written for

export const authors = groq`
  *[_type == 'author' && slug.current == $slug && archived == false][0]{
    _id,
  _updatedAt,
  name,
  'slug': slug.current,
  role,
  image,
  bio,
  socialMedia,
  }
`

*[_id == $authorId][0] {
  "subcategories": array::unique(*[_id in *[_type == "post" && references(^.^._id)].subcategory._ref])[] {
    _id,
    "path": "/news/" + parent->.slug.current + "/" + slug.current,
    title
  }
}