The home folder can be different for each site, so there's a table called SiteUser that maps users to sites. This table has a NodeID, which is the foreign key of the user's home folder, which is stored in the Node table.
SELECT UserName AS UserName, Configuration AS Path FROM [User]
INNER JOIN SiteUser ON SiteUser.UserID=[User].UserID
INNER JOIN Node ON SiteUser.NodeID=Node.NodeID
INNER JOIN Site ON SiteUser.SiteID=Site.SiteID