Compliance Categorization(ComplianceGroup) is stored in FieldDefinition object/entity. We can query the FieldDefinition object/entity to query Compliance Categorization for a Salesforce Field.
Sample SOQL:
SELECT Id, DeveloperName, ComplianceGroup
FROM FieldDefinition
WHERE EntityDefinitionId = 'Account'
AND DeveloperName = 'AccountNumber'
