Vincent Kompany has completed 10 years at Manchester City and says he wants to stay at the club after he retires as a player.