php mysql query problem

The picture above is a view. Now I have some problems when querying the view. Please help me!

I want to query the name inside. The restriction is
1.admin_type=0
2.related_eth_id=0
3.work_mode_related_name can be empty, but if it is not empty, it needs to be judged whether it is similar to the value of BRIDGE. If it is the value of BRIDGE, then judge the device_type. Whether the value is 0, if it is 0, then OK, otherwise it will not be queried, which is also a restriction

ps: This table is a table related to network interfaces and bridges. work_mode_related_name is the name of the network port bound to the previous network port (name). The problem here is that it needs to be judged when the network port is bound to a bridge (BRIDGE). device_type, because if the network port is bound to a network bridge, the network port will be normal when device_type=0, so this is the requirement. The above is about the network port. The bridge information can be roughly referenced for the convenience of the respondent! Thank you in advance, God

Reply content:

The picture above is a view. Now I have some problems when querying the view. Please help me!

I want to query the name inside. The restriction is
1.admin_type=0
2.related_eth_id=0
3.work_mode_related_name can be empty, but if it is not empty, it needs to be judged whether it is similar to the value of BRIDGE. If it is the value of BRIDGE, then judge the device_type Whether the value is 0, if it is 0, then OK, otherwise it will not be queried, which is also a restriction

ps: This table is a table related to network interfaces and bridges. work_mode_related_name is the name of the network port bound to the previous network port (name). The problem here is that it needs to be judged when the network port is bound to a bridge (BRIDGE). device_type, because if the network port is bound to a network bridge, the network port will be normal when device_type=0, so this is the requirement. The above is about the network port. The bridge information can be roughly referenced for the convenience of the respondent! Thank you in advance, God