$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);

SELECT
<br> `creator_account`.`user_name` AS `user_name`,
<br> `creator_account`.`main_design_folder` AS `mainFolder`,
<br> `creator_subfolder`.`design_sub_folder` AS `subFolder`,
<br> `fit_type`.`fit_category` AS `fitType`,
<br> `item_type`.`category_type` AS `category_type`,
<br> `gender_fit`.`fit_style` AS `fit_style`,
<br> `neck_line_type`.`style_type` AS `style_type`,
<br> `item_colour`.`colour_palette` AS `colour_palette`,
<br> `item_colour`.`colour_code` AS `colour_code`,
<br> `creator_test_imgs`.`img_location` AS `img_location`,
<br> `creator_subfolder`.`creator_accountID` AS `userID`,
<br> `item_colour_variant`.`item_colourID` AS `colourID`,
<br> `gender_fit`.`id` AS `genderID`,
<br> `item_type`.`id` AS `itemTypeID`,
<br> `creator_test_imgs`.`creator_subfolderID` AS `subFolderID`,
<br> `neck_line_type`.`id` AS `neckTypeID`,
<br> `item_colour_variant`.`id` AS `colour_variantID`,
<br> `fit_type`.`id` AS `fitTypeID`
<br>FROM ((((((((`creator_account`
<br> JOIN `creator_subfolder`
<br> ON (`creator_subfolder`.`creator_accountID` = `creator_account`.`id`))
<br> JOIN `item_colour_variant`
<br> ON (`item_colour_variant`.`creator_subfolderID` = `creator_subfolder`.`id`))
<br> JOIN `item_colour`
<br> ON (`item_colour_variant`.`item_colourID` = `item_colour`.`id`))
<br> JOIN `creator_test_imgs`
<br> ON (`creator_test_imgs`.`creator_subfolderID` = `creator_subfolder`.`id`))
<br> JOIN `gender_fit`
<br> ON (`creator_test_imgs`.`gender_fitID` = `gender_fit`.`id`))
<br> JOIN `item_type`
<br> ON (`creator_test_imgs`.`item_typeID` = `item_type`.`id`))
<br> JOIN `neck_line_type`
<br> ON (`creator_test_imgs`.`neck_line_typeID` = `neck_line_type`.`id`))
<br> JOIN `fit_type`
<br> ON (`creator_test_imgs`.`fit_typeID` = `fit_type`.`id`))