I think that is called a “mistress.”
No, this is different. A mistress is usually a woman a guy loves other than his wife and has a relationship that is more than just sex.