node-mysql 如何多次查询

Question

例如，mysql里有两个表:tb_user:userId,userNametb_userBook:userId,bookId,bookName想通过检索最终得到这样的结果：[{"userId":1,"userName":"张三","userBook":[{"bookId":1,"bookname":"书名1"},{"bookId":2,"bookname":"书名2"}...]},{"userId":2,"userName":"李四","userBook":[{"bookId":3,"bookname":"书名3"}]}...]如果是使用php的话，可以直接先获得所有tb_user的数据，然后遍历根据userId去搜索tb_userBook:

Answer 1

我使用node-mysql模块是这样干的。
SELECTa.userId,a.userName,b.userBook,b.bookIdfromtb_userasajointb_userBookasbona.userId=b.userId;
然后把结果拼成自己想要的格式