How to SELECT a sibling in an adjacency list type table?
It seems you need

SELECT t1.title taskTitle, 
       t2.title projectTitle
FROM tasks t1
JOIN tasks t2 ON t1.parent_id = t2.parent_id
             AND t1.position + 1 = t2.position
WHERE t1.id = 192