How to fetch the Salesforce Profile Name From User Object Using SOQL

Using Below SOQL, We can fetch the Profile name from User Object in single query itself:

Select Username, UserType, Title, ProfileId, Name, LastLoginDate, Id, Email, CompanyName, Alias, Profile.Name From User

Using Below SOQL, We can fetch the list of lost login user details in Profie wise:

Select Username, UserType, Title, ProfileId, Name, LastLoginDate, Id, Email, CompanyName, Alias, Profile.Name From User