How to correctly compose a database to get an array of the following type (more on that later)?

Question

MySQL

you need to get into the php code, after the request, an array of this kind,
for example

[
    'animal' => 'cat',
    'body' => ['head' => 1, 'paw' => 4],
    'ability' => ['run' => 10, 'jump' => 2]
]

on json does quite easily, through mysql how tables interact I can’t figure out how to design a table correctly, how many tables do I need to create at all?

Answer 1

Offhand two options.
Option #1, use if the 'body' and 'ability' sets are the same for all animals animal
table, fields: id (int), title (varchar)
animal_body table, fields: id (int), animal_id (int), head (int), paw (int)
animal_ability table, fields: id (int), animal_id (int), run (int), jump (int)
Option #2, use if 'body' and 'ability' sets are different for all animals
table animal, fields: id (int), title (varchar), body (json), ability (json)