Why did Zhou Yu lose his wife and his soldiers?

In Romance of the Three Kingdoms, Sun Quan wanted to take Jingzhou back from Liu Bei, so Zhou Yu offered a plan of "fake bride and fake hostage", but Zhuge Liang asked Liu Bei to take it to Sun Quan's mother Wu Guotai, so that he could take a vacation. Since then, there has been a saying that "Zhou Lang's coup is to protect the world-losing his wife and losing his soldiers".

It is not true that Zhou Yu lost his wife and his soldiers. Historically, Sun Quan married his sister to Liu Bei for political reasons. After Mrs. Sun married Liu Bei, she saw Liu Bei more and returned to Jiangdong a few years later.

The novel Romance of the Three Kingdoms artistically deals with this historical fact, saying that Sun Quan invited Liu Bei to visit Wu in order to recover Jingzhou, and that his sister was about to get married and wanted to discuss with Liu Bei. In fact, I just want to take Liu Bei hostage and coerce Shu to hand over Jingzhou.

But Zhuge Liang saw through Zhou Yu's plot. When Liu Bei arrived in Wu, he trumpeted that Liu Bei was going to marry Sun Quan's sister and told Sun Quan's mother, Wu Guotai. Wu Guotai was surprised at first, but later found that everyone knew about it. Besides, Gong Qiao said that he felt good after seeing Liu Bei himself, so he really married Sun Shangxiang to Liu Bei.

Although Sun Quan and Zhou Yu were very angry, they could only agree, so there was an allusion of "Zhou Lang decided the world-lost his wife and lost his soldiers".