当前位置：首页 > PHP

PHP实现分销数组

2026-02-15 15:03:10PHP

PHP实现分销数组的方法

在PHP中实现分销数组通常涉及处理层级关系的数据结构，例如多级分销系统中的用户关系或树形结构。以下是几种常见的实现方式：

递归构建多级分销数组

使用递归函数可以方便地处理无限层级的分销关系。假设有一个包含用户ID和上级ID的数组：

PHP实现分销数组

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

使用引用构建分销数组

对于大数据量的情况，引用方式效率更高：

function buildDistributionWithReference($users) {
    $tree = array();
    $references = array();

    foreach ($users as &$user) {
        $references[$user['id']] = &$user;
        $user['children'] = array();
    }

    foreach ($users as &$user) {
        if ($user['parent_id'] && isset($references[$user['parent_id']])) {
            $references[$user['parent_id']]['children'][] = &$user;
        } else {
            $tree[] = &$user;
        }
    }

    return $tree;
}

数据库查询优化

直接从数据库查询时可以使用CTE（Common Table Expression）或存储过程：

PHP实现分销数组

WITH RECURSIVE distribution_tree AS (
    SELECT * FROM users WHERE id = :root_id
    UNION ALL
    SELECT u.* FROM users u
    JOIN distribution_tree dt ON u.parent_id = dt.id
)
SELECT * FROM distribution_tree;

扁平数组转层级结构

将扁平数组转换为层级结构：

function flattenDistributionTree($tree, $level = 0) {
    $result = array();
    foreach ($tree as $node) {
        $node['level'] = $level;
        $result[] = $node;
        if (!empty($node['children'])) {
            $result = array_merge(
                $result, 
                flattenDistributionTree($node['children'], $level + 1)
            );
        }
    }
    return $result;
}

计算分销佣金

根据层级关系计算佣金：

function calculateCommission($tree, $rate = 0.1) {
    $total = 0;
    foreach ($tree as $node) {
        $total += $node['amount'] * $rate;
        if (!empty($node['children'])) {
            $total += calculateCommission($node['children'], $rate * 0.5);
        }
    }
    return $total;
}

这些方法可以根据具体业务需求进行调整，处理不同层级的分销关系、佣金计算和数据分析。