he426100/hyperf-user-relation

hyperf上下级关系组件

Maintainers

Details

github.com/he426100/hyperf-user-relation

Source

Issues

Installs: 19

Dependents: 0

Suggesters: 0

Security: 0

Stars: 0

Watchers: 1

Forks: 0

Open Issues: 0

pkg:composer/he426100/hyperf-user-relation

3.1.0 2023-12-01 08:04 UTC

Requires

Requires (Dev)

MIT a89d5086e977e7bf636105504ee5cf2f6231bf81

  • he426100 <mrpzx001.woop@gmail.com>

hyperf

This package is auto-updated.

Last update: 2025-10-29 03:18:32 UTC

README

受jtar-hyperf-user-node启发，把自己常用的用户关系实现发出来

Installation

  • Request
composer require he426100/hyperf-user-relation
  • Publish
php bin/hyperf.php vendor:publish he426100/hyperf-user-relation

用户关系表参考

CREATE TABLE `user_relation`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '父级ID',
  `user_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '会员ID',
  `level` int(11) UNSIGNED NOT NULL DEFAULT 1 COMMENT '关系等级',
  `create_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `parent_user_index`(`parent_id`, `user_id`) USING BTREE,
  UNIQUE INDEX `user_level_index`(`user_id`, `level`) USING BTREE,
  INDEX `rds_idx_0`(`user_id`, `parent_id`, `level`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = COMPACT;