public static function getAllparentCat() { $data = []; $parent = ProductCategorySelfRel::find()->where(['parent_cat_id' => 0])->all(); $i = 0; echo '<pre>'; foreach ($parent as $key) { $data[$i]['title'] = $key->category_name_with_cat_id->cat_title; $data[$i]['slug'] = $key->category_name_with_cat_id->cat_slug; $data[$i]['sort_order'] = $key->category_name_with_cat_id->sort_order; $data[$i]['desc'] = $key->category_name_with_cat_id->cat_desc; $i++; } return $data; }
public static function get_parent_cat($id, $data) { $parent = ProductCategorySelfRel::find()->where(['cat_id' => $id])->one(); if (!empty($parent)) { $parent_cat = self::find()->where(['id' => $parent->parent_cat_id])->one(); if (!empty($parent_cat)) { $data = $parent_cat->cat_slug . '/' . $data; self::get_parent_cat($parent->parent_cat_id, $data); } } return $data; }