@chacal1231,
Please take a look at this sample project on rendering stackedColumn chart using PHP and MySQL.
If you are further facing any issues, kindly share a sample project (along with sample database) over GoogleDrive or Onedrive reproducing the issue, so that we can look into your code, understand the scenario better and help you out.
__
Priyanka M S
Team CanvasJS