Moriarty reveals himself to be alive to John after the 2nd season finale. He also reveals that Sherlock is still alive, and Molly/Mycroft knew.

John is hurt and betrayed that Sherlock wouldn't confide in him, and it leads to semi-rebound John/Moriarty and dark!John. Whether he eventually gets over it or not is up to author.