How to use

tree

function

in

ParsedQs

router.get('/tree', async (req, res, next) => {
  var tree = req.query.tree;
  var result = {
    error: 0,
    data: {}
  };
  try {
    var sql = "select * from bs_menu where is_del=0 ";
    if(tree) {
      sql = sql + " and type = 0 "
    }
    sql = sql + "order by parent_id asc , menu_id asc";
    var menus = await mysql.query(sql);
    result.data = menus;
    res.status(200).json(result);

  } catch (e) {
    result.error = 1;
    res.status(500).json(result);
  }
});