How to get User details along with User License using SOQL in Salesforce?

Sample Query:

SELECT Id, Name, Profile.UserLicense.Name FROM User WHERE Name IN ( 'Magulan Duraipandian', 'Test Test' )

Output: