"Pleased for you" means "I am pleased on your behalf." I am happy because something good has happened for / to you.
"Pleased with you" means "I like how you are." I may enjoy you objectively (perhaps without our even being acquainted), or I may mean that our relationship is turning out well - on a personal basis, or perhaps on an employee/employer basis.