MYSQL Join table rows and use for php array -

i have multiple tables on specific database , each table similar each other.

table:

 id     series     folder   1      naruto     670   2      naruto     671   3      naruto     672 

each table has exact setup. series name changes. want pick 1 entry series row , highest number folder row. use data make php array , use json data. here code:

'select naruto.max(klasor), naruto.seri, one_piece.max(klasor), one_piece.seri, bleach.max(klasor), bleach.seri `naruto` inner join `one_piece` inner join `bleach on` limit 1' 

use group by clause like

select id,series,max(folder) max_folder table1 group series