The ex-attacker is set to move to a new role in Harrison as Special Assistant to the Sporting Director, after two seasons with Los Angeles FC and Columbus Crew respectively.
After confirming his retirement this week, the two-time Golden Boot winner has now officially signed off with the side he helped fire to a hat-trick of Supporters' Shield triumphs over a seven-year stint.
"It wouldn’t have felt right retiring somewhere else, especially in America, it wouldn’t have felt right," Wright-Phillips said in a statement. "I am honoured to get the opportunity to retire here, it means a lot to me."
Sporting Director Denis Hamlett, who Wright-Phillips will link up with, paid further tribute, adding: "There was no question in our minds to bring Brad back to the club following his retirement.
"The expansive experience that Brad brings from the field will be helpful in the development with our young players, while at the same time, Brad getting crucial experience on the sporting side for his own professional development."
Having broken through alongside brother Shaun at Manchester City, Wright-Phillips spent several seasons in the second and third tiers of English football, claiming the League One crown with Charlton Athletic in 2011-2012.
But it was in MLS where he made his name, joining the Red Bulls ahead of the 2013 season and helping to establish them as regular contenders.
He still holds the record for the most goals at the club, with 125, and won the Supporters' Shield on three occasions, in 2013, 2015 and 2018.
The bizarre incident occurred in stoppage time with the Red Bulls trailing 2-0 after Yearwood conceded a foul near the sideline, with the Englishman kicking away the ball in frustration.
Yearwood's errant kick cannoned into two young fans in the front few rows at Red Bull Arena, with a boy seen crying afterwards while a young woman seemed dazed. Yearwood immediately realised his error and attempted to apologise to the fans, by climbing into the stands but that effort was not accepted by those close to the shaken-up supporters.
The Red Bulls crowd could be overheard chanting against Yearwood before referee Timothy Ford gave him his marching orders.
The incident capped a poor night for the home side, with goals from Mikael Uhre and Daniel Gazdag clinching the win for Union, who sit top of the Eastern Conference.
Gazdag's goal, which came after Julian Carranza dispossessed Aaron Long, was his 18th of the campaign.
Dallas scored three goals in three minutes as Dallas firmed up their grip on a playoffs spot with a 3-0 road win over Minnesota United.
Michael Boxall netted a 55th-minute own goal before Alan Velasco curled in a right-foot strike less than a minute later.
Two minutes later, Velasco cannoned an effort into the crossbar with Jesus Ferreira glancing home their third after Sebastian Lletget collected the rebound and whipped in a cross.
Franco Fragapane was sent off for Minnesota, who also lost Emanuel Reynoso to a worrying ankle concern.
Cincinnati extended their unbeaten run to seven games and moved into the playoffs spots in the Eastern Conference with a 2-0 home win over Charlotte after goals from Nick Hagglund and Luciano Acosta.
Hany Mukhtar scored a double as Nashville claimed their fourth straight win and moved up to fourth in the west with an impressive 4-0 victory over Austin.
Columbus Crew missed a golden opportunity for three points with a 0-0 draw against struggling Chicago Fire.
