Collection group queries are only allowed from the root of the database.

[vanoorschot]

I have a Firestore database with this structure:
/organisations/{id}/players/{id}

When I run this query:

SELECT *
FROM GROUP players

I get this error:
Collection group queries are only allowed from the root of the database.

What am I doing wrong here?