# Get tree list with association table

**URL:** <https://discourse.cakephp.org/t/get-tree-list-with-association-table/7421>\
**Category:** Need Help\
**Created:** [March 6, 2020, 11:31pm UTC](https://discourse.cakephp.org/t/get-tree-list-with-association-table/7421 "2020-03-06T23:31:02Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![shadowx.jb](https://avatars.discourse-cdn.com/v4/letter/s/a88e4f/32.png) [@shadowx.jb](https://discourse.cakephp.org/u/shadowx.jb)\
**Post date:** [March 6, 2020, 11:31pm UTC](https://discourse.cakephp.org/t/get-tree-list-with-association-table/7421/1 "2020-03-06T23:31:02Z")

</div>

I have table tree and text table, I need the other table not to make array, but to have straight columns from the table.

```
     $data = $this->Navigations->find('children', [
        'for' => 2,
        'contain' => [
            'NavigationsSlugs' => [
                'conditions' => [
                    'NavigationsSlugs.language_id' => 1
                ]
            ]
        ],
        'conditions' => [
            'Navigations.aktivni' => 1
        ]
    ])->find('threaded');

```

NavigationsSlugs table - has no array, but only columns … is it possible?

 ![cake-table](https://canada1.discourse-cdn.com/flex029/uploads/cakephp/original/2X/4/49536cee8d5eb23e7e741dbc84e0fe9a5c815255.png)

Thank You!

---

<div class="post-metadata">

**Author:** ![coreytaylor](https://avatars.discourse-cdn.com/v4/letter/c/87869e/32.png) [@coreytaylor](https://discourse.cakephp.org/u/coreytaylor)\
**Post date:** [March 10, 2020, 7:17am UTC](https://discourse.cakephp.org/t/get-tree-list-with-association-table/7421/2 "2020-03-10T07:17:16Z")

</div>

You need to define a HasOne association instead of a HasMany.