"Part of me is afraid to get close to people because I'm afraid that they're going to leave"

This quote suggests that the speaker, Marilyn Manson, has a worry of forming close relationships with others due to the fact that of the prospective pain and frustration that might include the end of the relationship. They might have experienced desertion or betrayal in the past, causing them to develop a secured technique to forming connections with others.