instruction: Find users from a user's answers.
response: WITH CTE AS (SELECT OwnerUserId, Id, ParentId, Title, PostTypeId FROM Posts WHERE OwnerUserId = '##UserId##' AND PostTypeId = 2 UNION ALL SELECT p.OwnerUserId, p.Id, p.ParentId, p.Title, p.PostTypeId FROM CTE AS e INNER JOIN Posts AS p ON e.ParentId = p.Id AND p.PostTypeId = 1) SELECT c.OwnerUserId AS "user_link", u.DisplayName, u.Reputation, c.Id, c.Title, c.ParentId FROM CTE AS c LEFT OUTER JOIN Users AS u ON u.Id = c.OwnerUserId LEFT OUTER JOIN Posts AS q ON q.Id = c.ParentId WHERE c.PostTypeId = 1