I have three groups: "group_1", "group_2" and "group_3" I have two subgroups: "subgroup_1" and "subgroup_2" The subgroup "subgroup_1" has two users: "user1" and "user2". The subgroup "subgroup_2" has only "user1"
I want a query that returns all the subgroups where there is "user1", i.e. "subgroup_1" and "subgroup_2". How to get the children of the subgroups? This is possible?