mysql 一行两列_MySQL在两列中使用同一表行

我有一个名为Notifications的表,其中status = 1是EntryTime,status = 2是ExitTime.

+-----+------+------+------+--------+

| n_id| notification_time | status |

+-----+------+------+------+--------+

| 1 | 2016-11-17 16:44:02 | 2 |

| 1 | 2016-11-17 16:43:55 | 1 |

| 2 | 2016-11-17 13:05:47 | 1 |

| 2 | 2016-11-17 13:08:29 | 2 |

| 4 | 2016-11-17 14:09:02 | 1 |

| 4 | 2016-11-17 14:13:45 | 2 |

| 1 | 2016-11-17 22:05:02 | 1 |

| 1 | 2016-11-17 22:09:12 | 2 |

+----+------+------+-------+---------+

我需要一个类似的结果

+-----+------+------+------+--------+--------+--------+

| n_id| Entry_time | Exit_time |

+-----+------+------+------+--------+--------+--------+

| 1 | 2016-11-17 16:43:55 | 2016-11-17 16:44:02 |

| 2 | 2016-11-17 13:05:47 | 2016-11-17 13:08:29 |

| 4 | 2016-11-17 14:09:02 | 2016-11-17 14:13:45 |

| 1 | 2016-11-17 22:05:02 | 2016-11-17 22:09:12 |

+----+------+------+-------+---------+-------+--------+

有关如何执行此操作的任何建议？非常感谢！