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'