SQOL Query:

SELECT COUNT(AssigneeId) FROM PermissionSetAssignment WHERE Assignee.isActive = true AND PermissionSet.Name = 'My_Sample_PermissionSet'

Note: Change the Permission Set API Name as per your requirement.