问题描述
我正在开发一个包含二叉树的多级营销站点.
我能够生成树，但是我的问题是基于总左连接和总右连接进行计算.
您能建议任何方法或查询来计算吗?
我的表格结构是
User_id Left_id Right_id
1 2 3
2 4 5
3 6 7
4 8 9
5 10 11
6 12 13
7 14 15
这意味着对于user_id 1，leftcount = 8 rightcount = 7
结构如下:
1
2 3
4 5 6 7
8 9 10 11 12 13 14 15
Hi,
I am developing a multilevel marketing site which contains a binary tree.
I am able to generate the tree but my problem is calculating on total left join and total right join.
Can you suggest any method or query to calculate this.
My Table structure for this is
User_id Left_id Right_id
1 2 3
2 4 5
3 6 7
4 8 9
5 10 11
6 12 13
7 14 15
That means for user_id 1 leftcount=8 rightcount=7
structure is like below:
1
2 3
4 5 6 7
8 9 10 11 12 13 14 15
If anyone finds it do reply.
推荐答案
这篇关于多层次行销的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！