Manchester United midfielder Youri Tielemans has issued a public apology to Aston Villa fans after comments he made about his transfer sparked widespread backlash.