Generate php-array with mySQL output for JSON!

Hello,
I have a question about generating a php array from db-records for a JSON file.

The desired JSON output should look like that (however it could be ANY similar output, I would like to understand the translation process!)

[
 {
 "label": "CSP",
 "items": [
 {
 "label": "P dispute commission English",
 "text": "Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud...

Code (markup):

Generate php-array with mySQL output for JSON!

from PHP https://ift.tt/3dxbTaS
via IFTTT