1. They thought Charles would help them the way they had helped him, but as soon as they asked for help, he disappeared. He turned out to be just a fair-weather friend.
2. Everybody wanted to be Sally’s friend when she won the lottery. They weren’t real friends, however; they were fair-weather friends

The expression suggests the idea that someone is a friend only when the weather is good, i. e. , in good times.