CODE EXAMPLE FOR SQL

soql user profile

select user.id, user.Email,user.FirstName,user.LastName,user.profile.name,user.Username,user.IsActive FROM user , user.profile