array(17) {
[0]=>
array(3) {
["userid"]=>
string(1) "5"
["username"]=>
string(12) "qq17664ppp9"
["articles"]=>
array(9) {
[0]=>
array(6) {
["gamename"]=>
string(9) "太阳城"
["user"]=>
string(8) "aa123456"
["pwd"]=>
string(8) "bb123456"
["state"]=>
string(12) "开通成功"
["gnickname"]=>
string(6) "苦呀"
["regtime"]=>
string(10) "1436616315"
}
[1]=>
array(6) {
["gamename"]=>
string(8) "SK彩票"
["user"]=>
string(9) "aa123456a"
["pwd"]=>
string(9) "aa123456a"
["state"]=>
string(9) "审核中"
["gnickname"]=>
string(6) "累呀"
["regtime"]=>
string(10) "1436616315"
}
[2]=>
array(6) {
["gamename"]=>
string(6) "皇冠"
["user"]=>
string(8) "aa147258"
["pwd"]=>
string(8) "aa147258"
["state"]=>
string(12) "开通成功"
["gnickname"]=>
string(6) "水啊"
["regtime"]=>
string(10) "1436616315"
}
[3]=>
array(6) {
["gamename"]=>
string(9) "太阳城"
["user"]=>
string(7) "a789789"
["pwd"]=>
string(8) "aaa12374"
["state"]=>
string(9) "审核中"
["gnickname"]=>
string(12) "黑色的你"
["regtime"]=>
string(10) "1436622305"
}
[4]=>
array(6) {
["gamename"]=>
string(9) "太阳城"
["user"]=>
string(6) "a54545"
["pwd"]=>
string(6) "25e844"
["state"]=>
string(9) "审核中"
["gnickname"]=>
string(12) "黑色买眼"
["regtime"]=>
string(10) "1436622543"
}
[5]=>
array(6) {
["gamename"]=>
string(9) "太阳城"
["user"]=>
string(6) "a99999"
["pwd"]=>
string(6) "3def28"
["state"]=>
string(9) "审核中"
["gnickname"]=>
string(4) "ppdf"
["regtime"]=>
string(10) "1436622664"
}
[6]=>
array(6) {
["gamename"]=>
string(0) ""
["user"]=>
string(7) "mm78945"
["pwd"]=>
string(6) "61ad34"
["state"]=>
string(9) "审核中"
["gnickname"]=>
string(9) "白色式"
["regtime"]=>
string(10) "1436623045"
}
[7]=>
array(6) {
["gamename"]=>
string(26) "SK2（时时彩，3D彩）"
["user"]=>
string(5) "tt789"
["pwd"]=>
string(6) "ed20ec"
["state"]=>
string(9) "审核中"
["gnickname"]=>
string(9) "我我我"
["regtime"]=>
string(10) "1436623110"
}
[8]=>
array(6) {
["gamename"]=>
string(12) "皇冠体育"
["user"]=>
string(6) "zz789a"
["pwd"]=>
string(6) "e8f748"
["state"]=>
string(9) "审核中"
["gnickname"]=>
string(6) "小眼"
["regtime"]=>
string(10) "1436623324"
}
}
}
[1]=>
array(3) {
["userid"]=>
string(1) "6"
["username"]=>
string(8) "tztmt001"
["articles"]=>
array(1) {
[0]=>
array(6) {
["gamename"]=>
string(7) "游戏B"
["user"]=>
string(9) "aa1472587"
["pwd"]=>
string(9) "aa1472587"
["state"]=>
string(9) "审核中"
["gnickname"]=>
string(6) "火啊"
["regtime"]=>
string(10) "1436616315"
}
}
}
[2]=>
array(3) {
["userid"]=>
string(1) "7"
["username"]=>
string(8) "tztmt002"
["articles"]=>
array(0) {
}
}
[3]=>
array(3) {
["userid"]=>
string(1) "8"
["username"]=>
string(6) "qwe123"
["articles"]=>
array(0) {
}
}
[4]=>
array(3) {
["userid"]=>
string(1) "9"
["username"]=>
string(6) "zxc123"
["articles"]=>
array(0) {
}
}
[5]=>
array(3) {
["userid"]=>
string(2) "10"
["username"]=>
string(7) "zxc1234"
["articles"]=>
array(0) {
}
}
[6]=>
array(3) {
["userid"]=>
string(2) "11"
["username"]=>
string(8) "zxc12345"
["articles"]=>
array(0) {
}
}
[7]=>
array(3) {
["userid"]=>
string(2) "12"
["username"]=>
string(9) "zxc123456"
["articles"]=>
array(0) {
}
}
[8]=>
array(3) {
["userid"]=>
string(2) "13"
["username"]=>
string(6) "zxc147"
["articles"]=>
array(0) {
}
}
[9]=>
array(3) {
["userid"]=>
string(2) "14"
["username"]=>
string(9) "zxc123888"
["articles"]=>
array(0) {
}
}
[10]=>
array(3) {
["userid"]=>
string(2) "15"
["username"]=>
string(14) "zxc123dsafdsag"
["articles"]=>
array(0) {
}
}
[11]=>
array(3) {
["userid"]=>
string(2) "16"
["username"]=>
string(11) "tztmt789456"
["articles"]=>
array(0) {
}
}
[12]=>
array(3) {
["userid"]=>
string(2) "17"
["username"]=>
string(8) "tadflsal"
["articles"]=>
array(0) {
}
}
[13]=>
array(3) {
["userid"]=>
string(2) "18"
["username"]=>
string(11) "liangheizhi"
["articles"]=>
array(0) {
}
}
[14]=>
array(3) {
["userid"]=>
string(2) "19"
["username"]=>
string(9) "tztmt0789"
["articles"]=>
array(0) {
}
}
[15]=>
array(3) {
["userid"]=>
string(2) "20"
["username"]=>
string(10) "dfsaklfdjs"
["articles"]=>
array(0) {
}
}
[16]=>
array(3) {
["userid"]=>
string(2) "21"
["username"]=>
string(9) "tztmt123a"
["articles"]=>
array(0) {
}
}
}这应该算是二维数组了 我用了连贯操作。这是连表了，亲，我只需要查询出articles下 ["gamename"]= "太阳城" 的数据其它都不要。这个SQL如何写$Uid=session('uid');
$where = array();
$where['userid'] = session('uid');
$User = D("Users");
$map = array();
$gamename['gamename']='太阳城';
$map['articles']=array('EQ',$gamename);
$arr = $User->where($where and $map)->relation(true)->field('userid,username')->select();
var_dump($arr);
die();研究了两天还没有解决。菜鸟写程序还真不容易！ 最佳答案
