荣誉资质

try {
  let query = knex("cms_category")
    .select([
      "id",
      "pid",
      "name",
      "pinyin",
      "path",
      "orderBy",
      "target",
      "status",
      "listView",
      "articleView",
      "seoTitle",
      "seoKeywords",
      "seoDescription",
      "type",
    ]);

  if (pid === 0) {
    query.where("id", 0);
  } else {
    query.where("pid", pid);
  }

  query.orderBy("orderBy", "ASC");

  let res = await query;
  return res;
} catch (error) {
  console.error("Error executing query:", error);
  throw error;
}