Get Number of Active Users In a Public Group Using SOQL Query

SQOL Query:

SELECT COUNT(Id) FROM User WHERE Id IN (SELECT UserorGroupId FROM GroupMember WHERE Group.Name = 'Support Group') AND isActive = true

Note: Change the Group Name as per your requirement.