title: Store exploded GROUP_CONCAT columns to an array without nesting
body: <p>I'm working with a discography database and in order to make some instances of displaying data easier, I have a few columns in my SQL query that use GROUP_CONCAT().</p>
  <pre><code>SELECT
       aName as Album,
       atSong as Track_Number,
       tName as Track,
       GROUP_CONCAT(subTLV SEPARATOR ', ') as Option,
       GROUP_CONCAT(subTranslator SEPARATOR ', ') as Translator,
       GROUP_CONCAT(subLanguage SEPARATOR ', ') as Subtitles,
       GROUP_CONCAT(subURL SEPARATOR ', ') as SRT
  FROM ALBUM
       LEFT JOIN ALBUM_TRACK USING (aID)
       LEFT JOIN TRACK_SUBTITLES USING (tCode)
  WHERE aName = 'Album'
  GROUP BY tName
  ORDER BY subLanguage, subTLV, atSong
  </code></pre>
  <p>I am using a WHILE loop to retrieve results and store them in separate arrays and have two ways of doing it currently:</p>
  <pre><code>while ($row = mysqli_fetch_array($result)) {
       // method 1
       $GC_SUBS[$i_SUBS] = explode(', ', $row['Subtitles']);
       $i_SUBS++;
  
       // method 2
       $a_SUBS[$i_SUBS] = $row['Subtitles'];
       $i_SUBS++;
  }
  </code></pre>
  <p>For an album that has 4 tracks, the resulting arrays look like this:</p>
  <pre><code>// method 1
  array(4) {
    [0]=&gt;
    array(1) {
      [0]=&gt;
      string(7) &quot;English&quot;
    }
    [1]=&gt;
    array(2) {
      [0]=&gt;
      string(7) &quot;English&quot;
      [1]=&gt;
      string(6) &quot;Korean&quot;
    }
    [2]=&gt;
    array(1) {
      [0]=&gt;
      string(7) &quot;English&quot;
    }
    [3]=&gt;
    array(1) {
      [0]=&gt;
      string(7) &quot;English&quot;
    }
  }
  // method 2
  array(4) {
    [0]=&gt;
    string(7) &quot;English&quot;
    [1]=&gt;
    string(15) &quot;English, Korean&quot;
    [2]=&gt;
    string(7) &quot;English&quot;
    [3]=&gt;
    string(7) &quot;English&quot;
  }
  </code></pre>
  <p>Is there a way for me to both explode the strings and store it into an array that will result in only one level? This is what I'm trying to achieve:</p>
  <pre><code>array(5) {
    [0]=&gt;
    string(7) &quot;English&quot;
    [1]=&gt;
    string(7) &quot;English&quot;
    [2]=&gt;
    string(6) &quot;Korean&quot;
    [3]=&gt;
    string(7) &quot;English&quot;
    [4]=&gt;
    string(7) &quot;English&quot;
  }
  </code></pre>