In: SQL Server
Use a CTE to recursively roll up all descendant records into separate groups, regardless of level. Example data and Common Table Expression code included.