Miles O'Brien: Ends up transferring to DS9 after accepting a posting as Chief Operations Officer for the station. His wife Keiko and daughter Molly follow him and live on DS9 as well. Appears in multiple seasons of DS9.
Worf: Transferred to DS9 to command division following destruction of the Enterprise D (Star Trek Generations film). Eventually accepted position as Federation ambassador to Q'uonos. Appears in multiple seasons of DS9 as well as multiple TNG-era films.
Wesley Crusher: after resigning his commission with Starfleet, he opts to live on Dorvan V to learn from "The Traveler" to journey to other planes of existence. Does not appear on any other Star Trek series or films (however, a deleted scene from Nemesis shows Wes appearing once again in Starfleet uniform).
Dr. Beverly Crusher: Serves as Chief Medical Officer on Enterprise E under the command of Captain Jean Luc Picard. Does not appear on any other Star Trek series, but does appear in many of the TNG-era films (Insurrection, First Contact, Nemesis, Generations).
Cpt. Jean Luc Picard: Appears on DS9 a few times in the beginning season and during the Dominion War. Still in command of Enterprise E after the loss of the D vessel (Star Trek Generations), and all TNG-era films. Name is mentioned during Voyager.
Data: Did not appear on DS9, although did interact with Dr. Julian Bashir from DS9 while Enterprise D was in orbit of the station during a TNG episode. Appears in all TNG-era films.
Killed while in service aboard Enterprise E, by sending Picard back from the exploding Reman vessel instead of himself, sacrificing his life and ending his career.
Geordi LaForge: Serves aboard Enterprise E as Chief Engineer. Does appear in Star Trek Voyager in command of his own vessel in an alternate future timeline. Also appears in the TNG-era films.
Cmdr William Riker: Continued to serve as First Officer to Cpt Jean Luc Picard even during DS9 until after the events of Star Trek Nemesis. Eventually leaves the Enterprise E to command the USS Titan as Captain. Appears in the TNG-era films, in Enterprise (holo-deck episodes) and once on Voyager (thanks to Q).
Guinan: Serves as bartender in Ten-Forward on Enterprise D. Does not appear in any other Star Trek Series, except the TNG-era film Generations. Not clear what Guinan does after the D is destroyed.
Deanna Troi: Continues service aboard Enterprise E as ship's Counselor. Appears in the TNG-era films. Appears in Voyager and in Enterprise (holo-deck episodes). Eventually marries Cpt William Riker and eventually follows him to the Titan where they have a child.
Q: Included due to his multiple appearances across multiple series. Q appears quite frequently in TNG, Voyager, and DS9. Spreading his mischief and exploring what it means to be a "petulant" human from a Q's perspective, Q simply IS. Even after TNG, he IS. Period.