You aren't going to like this, but the equivalent to this is to simply just will yourself to "be charming." I DM D&D as well, so I know what this spell is, you'd have to be mad to want to use the real life equivalent of this on anyone you'll be seeing on a daily basis.
Through the path of Initiation, you become more Aware, and simply perceive your surroundings more clearly. Once you understand the situation, you learn how other people typically act, what's socially acceptable, and finally you understand yourself, which is the hardest part.
Once you're self aware, and aware in general, it's effortless to be affable, charming, a healing presence, and even terrifying at will. The average person operates entirely at the surface level, you just need to learn how to manipulate that surface, like playing with the water in a still pond, AFTER you become aware, of course, you need to go in order otherwise you'll be blindly making currents of chaos you won't understand.
What you're looking for is a quick fix to a very deeply rooted problem. Sorry to say you have a lot of work ahead of you.