Brian McFadden has apologised after posting a tweet condemning women who stay in abusing relationships.