MySQL nested JSON column search and extract sub JSON from the nested JSON

[LEFT]

[LEFT]
[LEFT]
[LEFT]
[LEFT]
[LEFT]
[LEFT]
[LEFT]
[LEFT]

[LEFT]

[LEFT]

[LEFT]

[LEFT]
[LEFT]
[LEFT]

[LEFT]

[LEFT]

[LEFT]
[LEFT]
[LEFT]

[LEFT]

[LEFT]