MySQL - Join multiple rows from other table as array : <p>I have trouble figuring out how to join multiple rows from a second table. I have tried using <code>GROUP_CONCAT</code> but I want to display them as an array <em>(see green box in the picture below)</em></p>

<p>The main issue here is the <code>1,2,4</code> from the airways-column. I really want to avoid having a third table just to connect the two tables together. I understand arrays are difficult to store in MySQL, but is there some magical way of getting the desired info from the tables below?  </p>

<p>I wish I had some code, but I am lost here. Very thankful for pointers!</p>

<p><a href="https://i.stack.imgur.com/bhtzL.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/bhtzL.png" alt="enter image description here"></a></p>
