SELECT 
  a.category_id 
FROM 
  cscart_categories as a 
  LEFT JOIN cscart_categories as b ON b.category_id IN (3168) 
WHERE 
  a.id_path LIKE CONCAT(b.id_path, '/%')

Query time 0.00491

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "858.08"
    },
    "nested_loop": [
      {
        "table": {
          "table_name": "b",
          "access_type": "const",
          "possible_keys": [
            "PRIMARY",
            "p_category_id"
          ],
          "key": "PRIMARY",
          "used_key_parts": [
            "category_id"
          ],
          "key_length": "3",
          "ref": [
            "const"
          ],
          "rows_examined_per_scan": 1,
          "rows_produced_per_join": 1,
          "filtered": "100.00",
          "cost_info": {
            "read_cost": "0.00",
            "eval_cost": "0.10",
            "prefix_cost": "0.00",
            "data_read_per_join": "2K"
          },
          "used_columns": [
            "category_id",
            "id_path"
          ]
        }
      },
      {
        "table": {
          "table_name": "a",
          "access_type": "index",
          "key": "id_path",
          "used_key_parts": [
            "id_path"
          ],
          "key_length": "767",
          "rows_examined_per_scan": 7821,
          "rows_produced_per_join": 868,
          "filtered": "11.11",
          "using_index": true,
          "cost_info": {
            "read_cost": "75.98",
            "eval_cost": "86.89",
            "prefix_cost": "858.08",
            "data_read_per_join": "2M"
          },
          "used_columns": [
            "category_id",
            "id_path"
          ],
          "attached_condition": "(`maniamall_cscart`.`a`.`id_path` like <cache>(concat('290/3168','/%')))"
        }
      }
    ]
  }
}

Result

category_id
3169
23494
23495
23496
23506
23507
23510
23524
23525
23733
23738
23768
23769
23776
23777
23785
23792
3170
3215
3220
3321
7897
7898
7908
8085
8086
8087
8092
8134
8709
9721
9728