Returns a long-format data frame of profile–category–group relationships. Each row represents a single combination of:
profileId
categoryId / categoryName (may be blank for legacy profiles)
groupId / groupName (may be blank for legacy profiles)
get_profiles_groups_categories()A data frame with columns:
profileId
categoryId
categoryName
groupId
groupName
Legacy profiles without groups or categories are still included, with blank group/category fields.
Internal function – use the exported wrapper(s) instead.