Ask a question about the query

Ask a question about the query
I have two sheets.
Table A ID name class number
Table B class number class Chinese name



In PHP, I want to show this

Software classes
Dick and Harry .....

Painting class

Harry........


How to express in PHP, in addition, I am using the smarty.

Php

------Solution--------------------
Select A. class number, B. class Chinese name, Group_concat (A. Name) as Name_group from Table A a LEFT join table b b on A. Class number =b class number group by A. Class number

It's easy to get the query out.
------Solution--------------------
When the associated query comes out, use an array to process ...
------Solution--------------------
PHP array

