If you go weak at the knees, you lose your strength and feel you are going to fall over, usually because of seeing or talking about either someone you are very attracted to or because of something unpleasant or frightening.

The thought of kissing him made me go weak at the knees. 吻他的念头让我膝盖发软。