/**
* 查询上级数据
*/
public function find_parent_info($uid, $field = "T2.uid,T2.nickname,T2.level,T2.goods_num", $condition = "T2.status = 1", $limit = 0) {
$prefix = Env::get('database.prefix', 'tp_');
$user_table = "user";
$sql = "SELECT {$field}
FROM (
SELECT
@r AS _id,
(SELECT @r := spread_uid FROM {$prefix}{$user_table} WHERE uid = _id) AS spread_uid,
@l := @l + 1 AS lvl
FROM
(SELECT @r := {$uid}, @l := 0) vars,
{$prefix}{$user_table} h
WHERE @r <> 0) T1
JOIN {$prefix}{$user_table} T2
ON T1._id = T2.uid
WHERE {$condition} ";
if ($limit > 0) {
$sql .= " ORDER BY T2.uid DESC LIMIT 0,{$limit}";
} else {
$sql .= "ORDER BY T1.lvl DESC";
}
return Db::query($sql);
}
