SELECT Id,Name,FirstName,LastName, UserRole.DeveloperName,UserRole.Name,Profile.Name,Profile.UserLicenseId,Profile.UserLicense.Name
FROM User where Profile.UserLicense.Name='Salesforce'
SELECT Id,Name,FirstName,LastName, UserRole.DeveloperName,UserRole.Name,Profile.Name,Profile.UserLicenseId,Profile.UserLicense.Name
FROM User where Profile.UserLicense.Name='Salesforce'