You must use magic as last resort only,remember that.You should try to socialise with them.
First of all;you don't have to attract people towards you,because in that instance,you win superiority,and that person isn't your friend anymore,just some sort servant.
Just think of whom would you want to befriend and try to get close to him/her.Friendship isn't based on attracting someone towards you,but staying with people with which you feel good.
On the other side,if you want to be the one who dominates the group just try befriending somewhat stupid people who are intellectually inferior to you.
In all cases,it must be you who will make the first move,that's simple:Help them when they need help.If you want real friends(or better say,equal friends),help them alot.If you want inferior friends,just help them with small things that won't affect you too much(simply don't put yourself on risk for them).
If nothing works,then ask magic for help.Just be careful with it,if you gain too much attention people might envy you and try to harm you,or you can attract bad company too.
I counsel you not to make yourself glamorous and attractive,but just to cast a spell to attract one or two specific persons you want to have for friends,or to pray(if you are religious) to the Gods to give you friends.
Gods are never wrong.They simply know what you really need,if,of course,you tell them.
Careful:Sometimes Gods don't give us what do we want,but they give us what do we want so deeply we never knew we did,or what we need. [From personal experience with Odin he nearly never gives me what I ask,always gives me what I want,but I don't know I want or what I deserve(if I ask too few he gives me more or if I ask too high he gives me less)]