Yeah, if you are doing a pie chart you will want to use a UNION.
Instead of joining in the user data, I'd probably pass in the userid through a url parameter and create a separate recordset for the user information.
Then add where clauses to each of your union select statements to filter those results by user as well.