将3个查询组合成一个数组(combining 3 queries into one array)

 有一个更好的方法吗？ 我有3个不同的查询，并希望将它们全部放入一个数组中。 因为我不能直接按照我想从查询中直接得到的方式排列它们，所以我必须在3个单独的查询中完成它（除非您知道在查询中执行此操作的方法）。 
 
 然后，我不得不创建单独的临时数组，所以我可以做一个foreach循环来使用array_push（）函数。 肯定有比这个笑声更好的方法。 
 
$sql = "SELECT prayers.*
    FROM prayers 
    LEFT JOIN prayed_for USING (postid) 
    WHERE prayed_for.username = '" . $_SESSION['user']['username'] . "' 
    and prayers.type = 'prayer' 
    and prayers.privacy != 'hidden'
    and 
    (
        (priority = 'emergency' and date > DATE_SUB(NOW(), INTERVAL 20 DAY)) 
    or 
        (priority = 'urgent' and date > DATE_SUB(NOW(), INTERVAL 40 DAY))
    ) 
    ORDER BY priority DESC, prayers.date DESC";

    $sql2 = "SELECT prayers.*
    FROM prayers 
    LEFT JOIN prayed_for USING (postid) 
    WHERE prayed_for.username = '" . $_SESSION['user']['username'] . "' 
    and prayers.type = 'prayer' 
    and prayers.privacy != 'hidden'
    and priority = 'normal' 
    and date > DATE_SUB(NOW(), INTERVAL 60 DAY)
    ORDER BY prayers.date DESC";

    $sql3 = "SELECT prayers.*
    FROM prayers 
    LEFT JOIN prayed_for USING (postid) 
    WHERE prayed_for.username = '" . $_SESSION['user']['username'] . "' 
    and prayers.type = 'prayer' 
    and prayers.privacy != 'hidden'
    and priority = 'long_term' 
    ORDER BY prayers.date DESC";

    $_SESSION['aprayers'] = send_query($sql);
    $rows2 = array();
    $rows2 = send_query($sql2);
    foreach ($rows2 as $row) {
        array_push($_SESSION['aprayers'],$row);
    }
    $rows3 = array();
    $rows3 = send_query($sql3);
    foreach ($rows3 as $row) {
        array_push($_SESSION['aprayers'],$row);
    }

Is there a better way to do this? I've got 3 different queries and want to put them all into one array. Since I can't just order them exactly the way I want straight from the query I'm having to do it in 3 separate queries (unless you know of a way to do it IN the query).
 
Then I'm having to create separate temporary arrays just so I can do a foreach loop to use the array_push() function. Surely there's a much better way than this lol.
 
$sql = "SELECT prayers.*
    FROM prayers 
    LEFT JOIN prayed_for USING (postid) 
    WHERE prayed_for.username = '" . $_SESSION['user']['username'] . "' 
    and prayers.type = 'prayer' 
    and prayers.privacy != 'hidden'
    and 
    (
        (priority = 'emergency' and date > DATE_SUB(NOW(), INTERVAL 20 DAY)) 
    or 
        (priority = 'urgent' and date > DATE_SUB(NOW(), INTERVAL 40 DAY))
    ) 
    ORDER BY priority DESC, prayers.date DESC";

    $sql2 = "SELECT prayers.*
    FROM prayers 
    LEFT JOIN prayed_for USING (postid) 
    WHERE prayed_for.username = '" . $_SESSION['user']['username'] . "' 
    and prayers.type = 'prayer' 
    and prayers.privacy != 'hidden'
    and priority = 'normal' 
    and date > DATE_SUB(NOW(), INTERVAL 60 DAY)
    ORDER BY prayers.date DESC";

    $sql3 = "SELECT prayers.*
    FROM prayers 
    LEFT JOIN prayed_for USING (postid) 
    WHERE prayed_for.username = '" . $_SESSION['user']['username'] . "' 
    and prayers.type = 'prayer' 
    and prayers.privacy != 'hidden'
    and priority = 'long_term' 
    ORDER BY prayers.date DESC";

    $_SESSION['aprayers'] = send_query($sql);
    $rows2 = array();
    $rows2 = send_query($sql2);
    foreach ($rows2 as $row) {
        array_push($_SESSION['aprayers'],$row);
    }
    $rows3 = array();
    $rows3 = send_query($sql3);
    foreach ($rows3 as $row) {
        array_push($_SESSION['aprayers'],$row);
    }

原文：https://stackoverflow.com/questions/31572456