Please take a look at this gallery page for an example on rendering PHP chart with data from database. You can use multi-series chart in your case. Please take a look at this sample project for an example on rendering multi-series chart with data from database.
—
Vishwas R
Team CanvasJS