Get Number of Active Users In a Role Using SOQL Query

SQOL Query:

SELECT COUNT(Id) FROM User WHERE UserRole.Name = 'Marketing Manager' AND isActive = true 

Note: Change the Role Name as per your requirement.