Little trouble with MySQL LEFT JOIN
Change the join condition to:

ON tb_user_messages_recap.Auteur = tb_user.Pseudo OR
   tb_user_messages_recap.Intervenant= tb_user.Pseudo


But really why not:

SELECT NIC_Handle
FROM tb_user
WHERE Pseudo =$_SESSION_PSEUDO


I could be wrong. Question is a bit ambiguous.