显示结果与ID相关并根据角色 - Laravel进行分类

Question

我有两个桌子主席和成员。

主席表

id | first_name | from | to | row_status 
-----------------------------------------
1 | old Chairman | 3-2017 | 5-2018 | 0
2 | Chairman | 6-2018 | 4-2018 | 1

成员表

id | chairman_id | | Name | role | row_status
-------------------------------------------
1 |  1 | president | P | 0
2 |  1 | vice president | VP | 0
3 |  2 | president | p | 1
4 |  2 | vice president | VP | 1

我试图根据主席向主席展示主席（Row_status = 1）主席和会员，

如果有多个主席，我不确定如何显示结果。

我目前正在显示下面的结果，

刀片页面

    @foreach ($statechairmans as $statechairman)
        <li>
            {{$statechairman -> first_name}}
        </li>
        <li> {{ $statechairman->statemembers->first_name }} </li>
    @endforeach

模型：

State Chairman 
  public function statemembers(){
        return $this->belongsTo('AppStatemembers', 'id','chairman_id');
    }
State Members
public function statechairman(){
        return $this->hasMany('AppStatechairman');
    }

我能够以预期的方式查看结果，但我不确定如何根据角色处理数据。

如何根据用户的角色显示并访问多个主席，以防万一，

eg，

Active
Chairman -> President -> Vice-President -> etc,
Old Chairman - 3-2017 | 5-2018
Chairman -> President -> Vice-President -> etc,

Answer 1

@foreach ($statechairmans as $statechairman)
        <li>
            {{$statechairman -> first_name}}
        </li>
        <li> {{ $statechairman->statemembers->first_name }} </li>
        @if($statechairman->row_status == 1)
             from : {{ $statechairman->from}}
             to:  {{ $statechairman->to}}
        @endif
@endforeach

希望它有帮助：）