How to withdraw features from the database?

The next question is database everything is stored in different tables(screen)6c08cf3ad369488f82febecfafa19125.png
when prompted
$sql="
SELECT car_type.name car_mark.name, car_model.name 
car_serie.name car_modification.name
car_characteristic_value.value car_characteristic.name
from car_mark
join car_model
on car_model.id_car_mark = car_mark.id_car_mark 
join car_type
join car_serie
on car_serie.id_car_model =car_model.id_car_model
join car_modification
on car_modification.id_car_model =car_model.id_car_model and car_modification.id_car_serie = car_serie.id_car_serie

join car_characteristic_value
on car_characteristic_value.id_car_modification = car_modification.id_car_modification
join car_characteristic
on car_characteristic.id_car_characteristic = car_characteristic_value.id_car_characteristic
limit 1500

";


it turns out

Array
(
[0] => motorcycles
[1] => BSE
[2] => PH06B
[3] => PH06B-50 10/10
[4] => 88cc (2.7 Hp)
[5] => pit bike
[6] => Type
)
Array
(
[0] => buggy
[1] => BSE
[2] => PH06B
[3] => PH06B-50 10/10
[4] => 88cc (2.7 Hp)
[5] => pit bike
[6] => Type
)
Array
(
[0] => ATV
[1] => BSE
[2] => PH06B
[3] => PH06B-50 10/10
[4] => 88cc (2.7 Hp)
[5] => pit bike
[6] => Type
)
Array
(
[0] => scooters
[1] => BSE
[2] => PH06B
[3] => PH06B-50 10/10
[4] => 88cc (2.7 Hp)
[5] => pit bike
[6] => Type
)

as to do so would be to a particular product for example
[0] => scooters
[1] => BSE
[2] => PH06B
[3] => PH06B-50 10/10
[4] => 88cc (2.7 Hp)
[5] => pit bike

added further characteristics which are in the database, now it creates each individual array
July 2nd 19 at 13:58
2 answers
July 2nd 19 at 14:00
car_characteristic_value.value car_characteristic.name
replace
car_characteristic_value.*, car_characteristic.*
July 2nd 19 at 14:02
fa8e228442d345caa795425095df46ca.pngd036d2b80c2c4c1d917eaa60e8d70c77.png

I enclose still look like the table in response to the top did not fit

Find more questions by tags PHPMySQL