$allBkArray = array();
$allLmArray = array();
$myQxArray = array();function getBkIdByLmId($lmId); //从lmId找bkId
//上面三个你怎么取
$myLmArray = array();foreach($myQxArray as $lmId){
$bkId = getBkIdByLmId($lmId);
if(!is_array($myLmArray[$bkId]){
$myLmArray[$bkId] = array();
}
$myLmArray[$bkId][] = $lmId;
}下面的你应该清楚了啥.
foreach($myLmArray as $bkId = > $lmArray){
output bk...
foreach($lmArray as $lmId){
output lm...
}
}
select b.版块id,b.版块名 from bk b left join lm l on b.版块id = l.版块id where 1