mysql - Multiple json from a database using php

Solution:

I suppose you could group your database rows and comma-delimit them so that they are flat, then unpack/explode them as you iterate.

SELECT errors.error_code,
       errors.issue,
       GROUP_CONCAT(DISTINCT errors.cause) AS causes,
       GROUP_CONCAT(DISTINCT errors.solution) AS solutions,
       GROUP_CONCAT(DISTINCT products.product) AS products
FROM errors 
JOIN products
    ON errors.issue = products.issue
       AND errors.error_code = products.error_code
WHERE errors.error_code = 'A01'
GROUP BY errors.error_code,
         errors.issue;

SELECT error_code, issue, cause, NULL solution, NULL product
FROM ERRORS
UNION ALL
SELECT error_code, issue, NULL, solution, NULL
FROM ERRORS
UNION ALL
SELECT id_error, issue, NULL, NULL, product
FROM PRODUCTS
ORDER BY error_code, issue, cause IS NULL, solution IS NULL