How to make a WQL Query for devices and join AD user fields, attributes or info?

I would like to create a query or queries in SCCM based on either the system resource or user resource grabbing a device with the attached user information such as department, title, manager other cu...