当前位置：首页 > PHP

PHP实现分销数组

2026-03-13 14:10:03PHP

PHP实现分销数组

在PHP中实现分销数组通常涉及构建多级分销关系的树形结构或扁平化数组。以下是几种常见的实现方法：

构建多级分销树

function buildDistributionTree($users, $parentId = 0) {
    $tree = [];
    foreach ($users as $user) {
        if ($user['parent_id'] == $parentId) {
            $children = buildDistributionTree($users, $user['id']);
            if ($children) {
                $user['children'] = $children;
            }
            $tree[] = $user;
        }
    }
    return $tree;
}

// 示例数据
$users = [
    ['id' => 1, 'name' => 'A', 'parent_id' => 0],
    ['id' => 2, 'name' => 'B', 'parent_id' => 1],
    ['id' => 3, 'name' => 'C', 'parent_id' => 1],
    ['id => 4', 'name' => 'D', 'parent_id' => 2]
];

$distributionTree = buildDistributionTree($users);
print_r($distributionTree);

扁平化分销数组

function getDistributionChain($userId, $users) {
    $chain = [];
    while ($userId != 0) {
        foreach ($users as $user) {
            if ($user['id'] == $userId) {
                array_unshift($chain, $user);
                $userId = $user['parent_id'];
                break;
            }
        }
    }
    return $chain;
}

// 示例
$userChain = getDistributionChain(4, $users);
print_r($userChain);

计算分销佣金

function calculateCommission($userId, $users, $salesAmount, $rates = [0.1, 0.05, 0.03]) {
    $commission = 0;
    $chain = getDistributionChain($userId, $users);
    foreach ($rates as $level => $rate) {
        if (isset($chain[$level])) {
            $commission += $salesAmount * $rate;
        }
    }
    return $commission;
}

// 示例
$commission = calculateCommission(4, $users, 1000);
echo $commission; // 输出: 180 (1000*0.1 + 1000*0.05 + 1000*0.03)

数据库查询优化

对于大型分销系统，建议使用数据库查询优化：

PHP实现分销数组

// 使用递归CTE查询 (MySQL 8.0+)
$sql = "WITH RECURSIVE distribution_tree AS (
    SELECT id, name, parent_id, 1 AS level FROM users WHERE id = ?
    UNION ALL
    SELECT u.id, u.name, u.parent_id, dt.level + 1 
    FROM users u JOIN distribution_tree dt ON u.parent_id = dt.id
) SELECT * FROM distribution_tree ORDER BY level";

// 使用PDO预处理
$stmt = $pdo->prepare($sql);
$stmt->execute([$userId]);
$distributionNetwork = $stmt->fetchAll(PDO::FETCH_ASSOC);

这些方法可以根据具体业务需求进行调整，适用于多级分销、团队计酬等场景。