public static function getChildrenSIDBySID($item_sid) { $children_sids = array(); $children = SJB_DB::query("SELECT sid FROM user_profile_field_tree WHERE parent_sid = ?n", $item_sid); if (!empty($children)) { foreach ($children as $child) { $children_sids[] = $child['sid']; $children_sids = array_merge($children_sids, SJB_UserProfileFieldTreeManager::getChildrenSIDBySID($child['sid'])); } } return $children_sids; }