thinkphp5多对多关联查询问题

浏览:7492 发布日期:2017/07/26 分类:ThinkPHP5专区
1.问题:在模型中定义查询字段后,只有最后一条数据能查到关联字段
Array
(
    [0] => Array
        (
            [id] => 51
            [username] => admin
            [password] => admin
            [name] => 测试1
            [department] => 工程部
            [mail] => guwenjun@wf-tech.com
            [phone] => 11112708515
            [logintime] => 1501045142
            [loginip] => 192.168.0.19
            [lock] => 1
            [groups] => Array
                (
                )

        )

    [1] => Array
        (
            [id] => 53
            [username] => test1
            [password] => 123
            [name] => 测试2
            [department] => 人力资源部
            [mail] => 123@qq.com
            [phone] => 12345678901
            [logintime] => 1500626980
            [loginip] => 192.168.0.86
            [lock] => 1
            [groups] => Array
                (
                )

        )

    [2] => Array
        (
            [id] => 54
            [username] => test2
            [password] => 123
            [name] => 测试3
            [department] => 行政部
            [mail] => 112@11.com
            [phone] => 12345678901
            [logintime] => 1499479115
            [loginip] => 192.168.0.19
            [lock] => 0
            [groups] => Array
                (
                    [0] => Array
                        (
                            [id] => 2
                            [title] => 行政管理组
                            [pivot] => Array
                                (
                                    [uid] => 54
                                    [group_id] => 2
                                )

                        )

                )

        )

)
2.如果我把filed字段去掉,查询出来是正常的
Array
(
    [0] => Array
        (
            [id] => 51
            [username] => admin
            [password] => admin
            [name] => 测试1
            [department] => 工程部
            [mail] => guwenjun@wf-tech.com
            [phone] => 11112708515
            [logintime] => 1501045142
            [loginip] => 192.168.0.19
            [lock] => 1
            [groups] => Array
                (
                    [0] => Array
                        (
                            [id] => 0
                            [title] => 系统管理组
                            [status] => 1
                            [rules] => 1,2,3,4,5,15,18,19,20,39,7,56,55,57,58,8,11,60,61,62,63,64,65,66,67,68,70,75,74,71,73,72,9,42,86,52,53,54,87,89,88,90,78,80,85,84,83,82,81,79,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,10,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170
                            [pivot] => Array
                                (
                                    [uid] => 51
                                    [group_id] => 0
                                )

                        )

                    [1] => Array
                        (
                            [id] => 1
                            [title] => 人事管理组
                            [status] => 1
                            [rules] => 1,2,182
                            [pivot] => Array
                                (
                                    [uid] => 51
                                    [group_id] => 1
                                )

                        )

                )

        )

    [1] => Array
        (
            [id] => 53
            [username] => test1
            [password] => 123
            [name] => 测试2
            [department] => 人力资源部
            [mail] => 123@qq.com
            [phone] => 12345678901
            [logintime] => 1500626980
            [loginip] => 192.168.0.86
            [lock] => 1
            [groups] => Array
                (
                    [0] => Array
                        (
                            [id] => 1
                            [title] => 人事管理组
                            [status] => 1
                            [rules] => 1,2,182
                            [pivot] => Array
                                (
                                    [uid] => 53
                                    [group_id] => 1
                                )

                        )

                )

        )

    [2] => Array
        (
            [id] => 54
            [username] => test2
            [password] => 123
            [name] => 测试3
            [department] => 行政部
            [mail] => 112@11.com
            [phone] => 12345678901
            [logintime] => 1499479115
            [loginip] => 192.168.0.19
            [lock] => 0
            [groups] => Array
                (
                    [0] => Array
                        (
                            [id] => 2
                            [title] => 行政管理组
                            [status] => 1
                            [rules] => 1,2,10,113,114,115,116,117,118,119,120,121,122,123,124,125,126,128,129,130,131,132,133,135,136,137,138,139,140,141,143,144,145,147,148,149,151,152,153,154,156,157,158,159,161,162,163,164,166,167,168,169
                            [pivot] => Array
                                (
                                    [uid] => 54
                                    [group_id] => 2
                                )

                        )

                )

        )

)
这个是我查询的方法不对吗?
最佳答案
评论( 相关
后面还有条评论,点击查看>>