$sql = 'SELECT
<br> creator_account.id,
<br> item_colour.colour_palette,
<br> item_colour.colour_code
<br> FROM
<br> creator_account
<br> INNER JOIN
<br> creator_item_colours
<br> ON
<br> creator_account.id = creator_item_colours.userID
<br> INNER JOIN
<br> item_colour
<br> ON
<br> creator_item_colours.item_colourID = item_colour.id';
<br>
<br>$data['item_col'] = $this-&gt;model-&gt;query($sql, 'array');
<br>$data['view_module'] = 'sidebar';
<br>$this-&gt;view('sidebar', $data);

&lt;li&gt;
<br>&lt;a href=&quot;#&quot; style=&quot;padding-left: 36px;&quot;&gt;Colour Pallete &lt;em class=&quot;mdi mdi-chevron-down&quot;&gt;&lt;/em&gt;&lt;/a&gt;
<br>&lt;ul class=&quot;subMenuColor2&quot;&gt;
<br>&lt;?php
<br>$categories = array();
<br>foreach ($item_col as $item_cols) {
<br>$categories[$item_cols['id']][] = $item_cols;
<br>}
<br>
<br>foreach($categories as $key =&gt; $item) {
<br>echo '&lt;div style=&quot;text-align: center;color: #fff;&quot;&gt;'.'This should be in dropdown '. $key.'&lt;/div&gt;';
<br>
<br>foreach ($item as $k=&gt;$items){ //inner loop
<br>echo '&lt;li class=&quot;colPallete&quot; data-cols=&quot;'.$items['colour_code'].'&quot;&gt;';
<br>echo '&lt;div class=&quot;inner-colID&quot;&gt;';
<br>echo '&lt;div class=&quot;colID&quot; style=&quot;background-color:'.$items['colour_code'].';&quot;&gt;&lt;/div&gt;';
<br>echo '&lt;a data-user=&quot;1&quot; href=&quot;#&quot;&gt;'.$items['colour_palette'].'&lt;/a&gt;';
<br>echo '&lt;/div&gt;';
<br>echo '&lt;/li&gt;';
<br>}
<br>}
<br>echo '&lt;/ul&gt;';
<br>echo '&lt;/li&gt;';
<br>echo '&lt;/li&gt;';

$data['item_col'] = $this-&gt;model-&gt;query($sql, 'array');
<br>json($data['item_col'], true);