问按日期将结果联系起来--甚至可以这样做吗？

EN

$member = $_GET['member'];
$date = $_GET['date'];

$firstRows = getMemberConnections($member)
$connections = array_merge($firstRows, getTree($firstRows));

$connectedMembers = array();
foreach ($connections as $connection)
{
    $connectedMembers[] = $connection['member1'];
    $connectedMembers[] = $connection['member2'];
}

$connectedMembers = array_unique($connectedMembers);
print_r($connectedMembers);


function getTree($rows)
{
    $subTree = array();
    foreach ($rows as $row)
    {
        $subTree[] = getMemberConnections($row['member1']);
        $subTree[] = getMemberConnections($row['member2']);
    }

    $subTree = array_unique($subTree);
    $subTree = array_merge($subTree, getTree($subTree));
    return $subTree;    
}

function getMemberConnections($member)
{
    global $date;
    $rows = array()
    $result = mysql_query("SELECT member1, member2 FROM MemberConnections WHERE (member1='$member' or member2='$member') and date >= '$date'") or die mysql_error();
    while ( $row = mysql_fetch_assoc($result) ) 
    {
        $rows[] = $row;
    }
    return $rows;
}

SELECT Member1 AS Member
  FROM MemberConnections
 WHERE Member2 = $userID
   AND Date BETWEEN $lo_date AND $hi_date
UNION
SELECT Member2 AS Member
  FROM MemberConnections
 WHERE Member1 = $userID
   AND Date BETWEEN $lo_date AND $hi_date;