SQOL Query:

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

Note: Change the Queue Name as per your requirement.